DSXchange

Posted: **Wed Aug 13, 2008 12:01 am**

In a server job, have two columns:
TranDate Decimal(8) values= 20080812
TranTime Decimal(8) values= 00000000

and want to load into db2 timestamp column: TrandtTime Timestamp

Thanks.

Posted: **Wed Aug 13, 2008 12:33 am**

Substring and concatenation will suffice.

Code: Select all

InLink.TranDate[1,4]:"-":InLink.TranDate[5,2]:"-":InLink.TranDate[7,2]:" ":InLink.TranTime[1,2]:":"InLink.TranTime[3,2]":":":InLink.TranTime[5,2]:".":InLink.TranTime[7,2]

I have assumed here that the final two digits of TranTime are centiseconds.

Posted: **Wed Aug 13, 2008 9:51 am**

I used following and it worked:

Code: Select all

Oconv(Iconv(a.TRANDATE_C702,"D YMD"),"D-YMD[4,2,2]"): " " : Oconv(Iconv(svTime, "MTS"),"MTS")

DSXchange

Making Timestamp column for DB2

Making Timestamp column for DB2