Making Timestamp column for DB2

[ds2000]

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.

[ray.wurlod]

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.

[ds2000]

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")