DataStage Warning......

[akhila.chitti]

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.

[ArndW]

Yes, this is because DataStage is trying to convert a row's string data to numeric and the data contains non-numeric data. You cannot get rid of this error without actually correcting your data. Perhaps you could put in a derivation such as

Code: Select all

IF NOT(NUM(In.Column)) THEN 0 ELSE In.Column