Search results for query: *

Hi I am not able to load the data from dataset for a column data type defined as Char and the data having - (hypen) in the data like abc-def. Please help me to load the data into the table. thanks in advance Hari

Hi I have table with a_bc_de column decimal(15,2). The data has to be loaded using Load utility. The data is in text format for this decimal column say 12324343.23, but the load card for this column will be like A_BC_DE POSITION( 37: 44 ) DECIMAL PACKED...

Hi Is the data type is SMALLINT or INTEGER. The smallint allows only upto 32767. check the table definition. Hari

Hi We are able to store upto 999,999. didn't faced any problems. May I have your insert statement. try integer(col) in insert statement. Hari

Hi Blom Thanks for your suggestion. I tried executing the SQL, it gave same result as having multiple OR's. But it took more CPU time. Hari

Hi Is it possible to convert date in DD-MM-YYYY to DB2 format YYYY-MM-DD during the load from flat file. I receive the date from other Database in format DD-MM-YYYY. Please advise on the method to convert to DB2 format during load. Hari

I am not sure of it, but think it is V7.0. Is it possible to find version details using an SQL, if so pls advise. thanks for your time. Hari

here I am giving only where clause. existing where clause is having so many or conditions, can I replace with Case. Please suggest. Where ( a = 1 and b=2) or (a=3 and b=4) or (a=4 and b=8) Can replace with Where Case When ( a = 1 and b=2) then " here what should we do" When (a=3...

Thank you very much. Actually data type of A.T is timestamp and data type of B.T is time, so I want to update the HH.MM.TT in A.T with the Time value in B.T. You advised that function cannot work in update. thank you for ur suggestion. hari

Hi I have a problem in update, getting SQLcode -104 UPDATE D1.T_A A SET TIME(A.T) = (SELECT B.T FROM D1.T_H B WHERE A.ID = B.ID AND A.TMST = B.TMST) A.T col is timestamp and it have current timestamp value. B.T col is TIME, I want to update the time value in A.T Timestamp with...

Hi If you have Platinum tool, then go to Rc/query and give the table name you get the length. Hari TCS

Hi JK Try this SELECT (WHEN LENGTH(RTRIM(xxxxx)) =3 THEN CHAR(000) CONCAT CHAR(xxxxx) ELSE xxxxx END ) AS yyyy Hari TCS

You can use the parameter FETCH FIRST 1 ROW ONLY and remove the group by and order by. This will work only in DB2..If it is another, search for similar statement.