Populating values into a column which datatye is timestamp

puli.reddy · Post by **puli.reddy** » Sat Feb 11, 2006 3:46 am

Hi,

I want to populate values into a DB2 database column which datatype is timestamp. Input values are coming as follows
200602111743(YYYYMMDDHHMI). I am moving directly without any transformation logic. It isn't allowed to populate values into database.

What transformation logic should I have to use for this population?

Thanks in advance.

ArndW · Post by **ArndW** » Sat Feb 11, 2006 4:17 am

AnjinReddy,

you posted the question in a PX forum, but specified Windows/Server in the comments. Could you specify which system you are actually using, and what your error message is?

tardifma · Post by **tardifma** » Sun Feb 12, 2006 10:50 am

Hi.
In the server edition, look at the IConv and OConv option. With these 2 function, you can convert string to datastage date format. Look at the IConv's help for the format...

Mathieu.