Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hnkadmn
  • Content: Threads
  • Order by date
  1. hnkadmn

    Load problem for Char column

    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
  2. hnkadmn

    Load problem for data type decimal

    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...
  3. hnkadmn

    Date conversion during table load from file

    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
  4. hnkadmn

    need help on CASE usage in Where clause

    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...
  5. hnkadmn

    Update problem

    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...

Part and Inventory Search

Back
Top