DSXchange

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.

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?

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.