DataStage Warning......
Posted: Thu Dec 06, 2007 12:25 am
Hello,
I am trying to run a load job, writing the data from a fixed-width seq file to the table. In my job, 2 of my columns in the file are Char by nature and when getting loded into the table, they become Numeric by nature. The job runs fine but tends to generate a warning:
Program "JOB.208035487.DT.1458444514.TRANS1": Line 122, Nonnumeric data when numeric required. Zero used.
Is it becos of the change in the metadata that i get this message? If so, what is the optimal solution to handle this?
Thanks in advance,
Akhila.
I am trying to run a load job, writing the data from a fixed-width seq file to the table. In my job, 2 of my columns in the file are Char by nature and when getting loded into the table, they become Numeric by nature. The job runs fine but tends to generate a warning:
Program "JOB.208035487.DT.1458444514.TRANS1": Line 122, Nonnumeric data when numeric required. Zero used.
Is it becos of the change in the metadata that i get this message? If so, what is the optimal solution to handle this?
Thanks in advance,
Akhila.