error

bobby · Post by **bobby** » 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

ketfos · Post by **ketfos** » Thu Aug 26, 2004 10:14 am

Hi,
What is the data type of the target field and input field?
Are you using any routine/function in transformer for converting input date value?

Ketfos

roy · Post by **roy** » Thu Aug 26, 2004 10:20 am

Hi,

DataStage Job 1399 Phantom 22463
Program "JOB.769250073.DT.1337842651.TRANS1": Line 239, Nonnumeric data when numeric required. Zero used.

means that if you'll look in the RT_BP1399 directory in your project directory you'll find the basic code of your compiled job transformer (named "JOB.769250073.DT.1337842651.TRANS1"), in it at line 239 is the exact expression that had the error.
to get the exact colum name search in the beginning of the file for the related symbol to the expression at line 239.
after doing this you'll have the exact column name and you still need to find why it had the unexpected value in it.
it could be due to having the wrong table definition or garbage data or some other odd reason.

Good Luck,

bobby · Post by **bobby** » Thu Aug 26, 2004 1:02 pm

Hi,
its date type format
Thanks,
Bobby

ray.wurlod · Post by **ray.wurlod** » Thu Aug 26, 2004 5:01 pm

If you read my response to your original post on this topic, you will note that I told you what you were doing wrong, and predicted that this error message would appear.