error
Posted: Thu Aug 26, 2004 7:40 am
Hi frnds,
I am getting this error i have hard code my effective date in Transformer
'2500-01-01 00:00:00' as i am trying to convert this effective date
with the end date i saw this error ,My end date is in DSJOBSTARTdate
when i am using IF DSLink10.DIM_FWFM_JOB_KEY <> DSLink4.DIM_FWFM_JOB_KEY then DSLink4.END_DT else DSLink4.EFF_DT
then this error comes (plz inform if u guys understand what is am trying to say)
DataStage Job 1399 Phantom 22463
Program "JOB.769250073.DT.1337842651.TRANS1": Line 239, Nonnumeric data when numeric required. Zero used.
Thanks
Bobby
I am getting this error i have hard code my effective date in Transformer
'2500-01-01 00:00:00' as i am trying to convert this effective date
with the end date i saw this error ,My end date is in DSJOBSTARTdate
when i am using IF DSLink10.DIM_FWFM_JOB_KEY <> DSLink4.DIM_FWFM_JOB_KEY then DSLink4.END_DT else DSLink4.EFF_DT
then this error comes (plz inform if u guys understand what is am trying to say)
DataStage Job 1399 Phantom 22463
Program "JOB.769250073.DT.1337842651.TRANS1": Line 239, Nonnumeric data when numeric required. Zero used.
Thanks
Bobby