Nonnumeric data when numeric required. Zero used

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
devaraj4u
Participant
Posts: 32
Joined: Mon Nov 11, 2002 12:32 am
Location: Schaumburg,Chicago

Nonnumeric data when numeric required. Zero used

Post 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.
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post 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
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”