Nonnumeric data when numeric required. Zero used
Posted: Mon Sep 15, 2003 12:21 am
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.
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.