DSXchange

Posted: **Thu Aug 18, 2005 12:33 pm**

Hi All,

I have a job which loads from a fixed width file to a flat-file. But I get this warning.

The source file has <100 records.

Code: Select all

DataStage Job 95 Phantom 3820
Program "JOB.612099343.DT.1374470452.TRANS1": Line 280, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 270, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 272, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 274, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 276, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 278, Nonnumeric data when numeric required.  Zero used.
Program "JOB.612099343.DT.1374470452.TRANS1": Line 280, Nonnumeric data when numeric required.  Zero used.
DataStage Phantom Finished

I'm not able to decipher this warning. Did anybody encounter such warning before. Please let me know.

Thanks,
Naveen.

Posted: **Thu Aug 18, 2005 12:52 pm**

Navenn,

in your TRANS1 transformer you are performing some mathematical derivation on your data, but some value is not a number (i.e. it contains a character) and thus Datastage uses a 0 instead of aborting. So, check your transform stage for derivations...

Posted: **Thu Aug 18, 2005 12:59 pm**

Hi Naveen,

This warning is very descriptive, and apears for example when you use a function like "INT(CHAR)".
Check the job design, you also can find this file "JOB.612099343.DT.1374470452.TRANS1" and check the lines 280, 270...

Posted: **Thu Aug 18, 2005 1:58 pm**

Try this DIGITS(DSLinkNN.ColName) in your tranformer for all numeric targets

Kewl

DSXchange

Warning Message

Warning Message