Page 1 of 1

Nonnumeric data when numeric required. Zero used

Posted: Mon Sep 15, 2003 12:21 am
by devaraj4u
Dear All,

I have a job in which i am taking the source file and writing the same to different text files depends on one field length(basically spiliting the records based on one field total length. The Job is running file and producing the output without any problems but i m getting the following error could you please help me memebers.

Error in Ardent (Job Log) what i m getting?
-------------------------------------------

DataStage Job 165 Phantom 559
Program "JOB.178554976.DT.1298912216.TRANS4": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 927, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 948, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 969, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 990, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1011, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1032, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1053, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1074, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1095, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 927, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 948, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 969, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 990, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1011, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1032, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1053, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1074, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1095, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 927, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 948, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 969, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 990, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1011, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1032, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1053, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1074, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1095, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 927, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 948, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 969, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 990, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1011, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1032, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1053, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1074, Nonnumeric data when numeric required. Zero used.
Program "JOB.178554976.DT.1298912216.TRANS4": Line 1095, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished


Thanks & Regards,
K.S.Rajan.

Posted: Mon Sep 15, 2003 7:12 am
by kcbland
You've obviously got nonnumeric data being used in a mathematical expression somewhere. Look at all the functions you are using and figure out which one has the problem. If you copied this job from another, make sure to go check all key expression derivations for hidden function usage, as well as link constraints and stage variables. You might have a stage variable being derived, but don't see it because you turned off the showing of stage variables.

Kenneth Bland