date warning

rajan.n · Post by **rajan.n** » Thu Feb 01, 2007 9:50 am

Hi ,
An intial intro to my self : am new to server jobs.
jst have a warning which aborts my job, i want to fix that warning,i need ur help.
the warning is like this:

Transformer_7: At row 1, link "DSLink8", while processing column "CNT_DT"
Value treated as NULL
Attempt to convert String value "2002-01-21" to Date type unsuccessful

can you pls help me in this issue.
thanks much in advance.
rajan.

chulett · Post by **chulett** » Thu Feb 01, 2007 10:24 am

Target database? Stage used? Derivation? Details, man, details!

rajan.n · Post by **rajan.n** » Thu Feb 01, 2007 10:32 am

chulett wrote:Target database? Stage used? Derivation? Details, man, details! ...

hey chulett...

am sorry ,
my source is seq and target is db2, there is only a transformer between the seq and DB2-api stage.

i tried using
Oconv(Iconv(T1.CNT_DT,"D-YMD"),"D-YMD[4,2,2]")
but did not worked.

thnx for ur reply ,was waiting for that.
rajan.

chulett · Post by **chulett** » Thu Feb 01, 2007 10:56 am

DB2 wants dates in internal format, from what I recall. Try just the Iconv part and see how that works.

rajan.n · Post by **rajan.n** » Thu Feb 01, 2007 11:02 am

chulett wrote:DB2 wants dates in internal format, from what I recall. Try just the Iconv part and see how that works. ...

what u said is perfect...!!
no warnings regarding this kind of.
thanks a lot,but there are other kind of warnings again the job has aborted,
anyhow am happy that one thing has resolved.
thanks a lot chullet..!!

chulett · Post by **chulett** » Thu Feb 01, 2007 11:04 am

Excellent. Please mark the post as Resolved.

DSguru2B · Post by **DSguru2B** » Thu Feb 01, 2007 1:46 pm

Keep in mind that this is true only for Date columns. For timestamps, the output should be in external format(if thats a word).