I have a table with only 1 column as Table : profileTable //————– profile XML; //————– A sample content of XML file is <sampleprofile name="joe" version="A123"> <phone>123456789</phone> .. .. </sampleprofile> //—————————- ——– How can we create a UNIQUE index which includes both the ‘name’ and
Read full story
Hi! I’m using COM.ibm.db2.jdbc.app.DB2Driver driver. When executing a CallableStatement I get back a DB2Warning that has a method getErrmc() to get the SQLERRMC data in this form: SYSPROC.ADMIN_CMD�SQL3235� Through trial and error I got to the conclusion that the delimiter in ERRMS i (char) 65533.
Read full story
Chris Eaton created a SP to to transpose rows to columns : Here is an example of a rowtocol stored proc that takes a SQL statement as the first paramter, a delimiter as the second parameter and the ouput (in the 3rd parameter) is the rows coverted to a column with the delimiter specified used to separate the row values.
Read full story
Hi, I have been trying to find a reasonable GUI SQL client that displays results without rounding them. I was pointed to IBM’s Data Studio, which we’ve FINALLY installed, but sadly it seems it also rounds. If I do this query from the command line: SELECT * FROM TARGET WHERE file_id = 8237 and accession_id =
Read full story
I am working on a client system and I got the error for db2vshelpreg.exe when I installed the IBM DB2 client. But the Db2 client works fine. Now I am getting this error when installing Toad for DB2 and when changing DB2 default copy thru DB2 selection Wizard or db2swtch. Before I installed the DB2 client the system did not have DB2 and
Read full story
Environment is DB2/LINUX 9.5.0. I wonder if it is possible to set the MESSAGE_TEXT dynamically when using the SIGNAL statement. The objective is to return more specific information to the calling user or application. E.g. I would rather return "Unknown value 42" than just "Unknown value". The documentation says:
Read full story
Hi, We have an immediate opening for one of our MNC client. The candidate should have experience in the following skills: Java, J2ee, spring, hibernate. Experience in jsf, webservices is an added advantage. Experience level: 3.8 - 8 years Location: Bangalore Plz send across your updated profile in word format along with the
Read full story
DB2 V8.2 on AIX using C language applications. I have these two queries I would like to put together: "SELECT SUM(products.loc1_size) FROM products WHERE (location1 = ‘NFUSA1′) AND (main_loc IN (SELECT main_loc FROM status WHERE backordered = ‘N’)) AND (products.main_loc IN (SELECT main_loc FROM main_store WHERE location = ‘NFUSA1′ AND location IN (SELECT item from
Read full story