TimeStamp problem with DB2UDB Stage
Posted: Mon Jul 24, 2006 5:49 pm
Hi
One of my source column in my source file is in this format yyyy/mm/dd hh24:mi:ss.000000 and my target is in db2udb with a column of datatype timestamp.
If I just pass on the column I get this error...
Value treated as NULL
Attempt to convert String value " " to Timestamp type unsuccessful
If I do the following in the thransformer ...
ICONV(L1.END_DT,"D-YMD[4,2,2]"):" ":ICONV(L1.END_DT,"MTHS")
I get this error...
Value treated as NULL
Attempt to convert String value " 0" to Timestamp type unsuccessful
Please share some ideas...
Thanks
One of my source column in my source file is in this format yyyy/mm/dd hh24:mi:ss.000000 and my target is in db2udb with a column of datatype timestamp.
If I just pass on the column I get this error...
Value treated as NULL
Attempt to convert String value " " to Timestamp type unsuccessful
If I do the following in the thransformer ...
ICONV(L1.END_DT,"D-YMD[4,2,2]"):" ":ICONV(L1.END_DT,"MTHS")
I get this error...
Value treated as NULL
Attempt to convert String value " 0" to Timestamp type unsuccessful
Please share some ideas...
Thanks