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.
DataStage Warning.....
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Fri Jul 06, 2007 3:10 am
DataStage Warning.....
Akhila Chitti
Software Engineer
HSBC, GLT.
Hyd.
Software Engineer
HSBC, GLT.
Hyd.
Hi,
The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.
It should be some prob with the data. As such server job's will not give such prob.
Regards,
The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.
It should be some prob with the data. As such server job's will not give such prob.
Regards,
Regards,
Shree
785-816-0728
Shree
785-816-0728
Hi,
The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.
It should be some prob with the data. As such server job's will not give such prob.
Regards,
The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.
It should be some prob with the data. As such server job's will not give such prob.
Regards,
Regards,
Shree
785-816-0728
Shree
785-816-0728
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Re: DataStage Warning.....
you just cant load a char into an integer, you need to handle the spaces if any or check for any alphabetic or non-numeric characters.akhila.chitti wrote: 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:
from your error message, it seems that you got an non-numeric character in one of the CHAR fields.