Hello fellows, good day. I am using an OLEDB connection to connect to DB2 database. I am having problems mapping the dates from database inside .NET. In my business object I defined a private DateTime _genftmdpdate=DateTime.MinValue; But whenever I fetch the date from database and populate inside my variable I get Specified Cast not val...
Hello fellows, I am very new to stored procedures. I am trying to make a stored procedure which would perform an update accepting 2 input parameters and return the number of records updated (in my case always 1). I have managed till this so far but I don't understand how to return the variable after opening the cursor. Is the cursor nec...
HI, Is it possible to generate SQL Script to create table schema along with the data currently present in the table. Thanks ...
I've worked with some open source databases (mysql, postgres and firebird). They all have small and lean drivers for ado.net and are quite easy to configure. I'm currently working with IBM/DB2 and Oracle. They are hard to get working and you have to install several megabytes to get a small driver. Why can't they create drivers that are ...
I am trying to create a view to transparently handle encryption of a BLOB column. I am using the approach described here. Background NOTE There was a comment by @tc, asking why I am trying to encrypt this, since the encryption key is then stored (in plain text) in the code. I have a requirement to encrypt the data a...
My current knowledge: Oracle does offer index-organized tables and defaults to heap-organized. I heard that SQL-Server uses only index-organized tables I am especially interested in answers for MySQL, Informix and DB2. ...
I have a Rails App and users are pasting certain values from MS Word. When I pasted this... Paul’s “Test2” This is what gets rendered in the app... Paul’s “Test†However, and this is the most bizarre aspect of this - this does not happen at once and I have not been able to track the specific circustances that leads to it. So a ...
Is there any way to migrate a DB2 Database to SQL Server 2005 Standard? ...
I built several stored procedures. And I "deployed" them with the setting "enable debugging". And I right click on the stored procedure and click on "DEBUG". However, it just runs without stopping at the breakpoints I set. What is wrong with this? Am I missing something? I'm using the latest Data Studio downloaded from IBM website. ...
In DB2 , how do we write a query to fetch value from clob datatype column ...
I am a java programmer and planning to take up a DB2 certification. Please advice on which books to prefer. ...
Hi, how to insert to a identity column using sequences in DB2? Thanks in advacne ...
I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the like command once I have all the tables. ...
Hello..I have some doubts on using DECIMAL datatype in DB2 database.there is one datatype DECIMAL in DB2...can we use this datatype for representing a interger value???..If yes then Is it efficient then Interger Datatype??.....In My Database all the integer values are defined as DECIMAL datatype....How is it Useful here to use Decimal d...
I'm having trouble executing a stored procedure in ODBC to a DB2 database where a stored procedure has multiple input and output params. If I specify only in input params in the call statement with ? like below, i get "SQL0440 - Routine XXXXXXX in *N not found with specified parameters.". I've changed the output params to be of type 'Ret...
I am really confused between which certification to take up? Both of them are good for DBA. I have started working with Oracle and have no knowledge of both the databases. ...
I have a table that has something like half a million rows and I'd like to remove all rows. If I do simple delete from tbl, the transaction log fills up. I don't care about transactions this case, I do not want to rollback in any case. I could delete rows in many transactions, but are there any better ways to this? How to efficiently r...
In Oracle we can do it like this: declare current_max_value NUMBER; begin select last_number+1 into current_max_value from USER_SEQUENCES where sequence_name = 'HIBERNATE_SEQUENCE'; execute immediate 'CREATE SEQUENCE SEQ__NEW_SEQUENCE MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH '||current_max_value|| ' CACH...
I want to do something like this: INSERT INTO TABLEA ( COLUMN1, COLUMN2, COLUMN 3 ) SELECT FOOBAR, DOOBAR, ? FROM TABLEB And then send this to JDBC via Spring JDBC to update... simpleJdbcTemplate.update( mySqlFromAbove, someVariableToReplaceQuestionMark ); Is this even possible? It would work fine if I replace the question mark wi...
I am trying to connect to a IBM DB2 9 database on a Linux server from my Java application. I am using db2jcc.jar (DB2 Universal JDBC Driver). Establishing a connection takes a ridiculous amount of time? What could be wrong? I know there a lot of factors that could cause this, but I am willing to get down to the root cause. Please help me...