DSXchange

Hi All,

I am getting this warning message while running the datastage job.

"DataStage Job 2611 Phantom 16948
Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnumeric data when numeric required. Zero used."

Please help me to resolve this.
No oracle stage is used in the job.

Thanks
Raghu

Raghu,

I think you are getting this message because you are performing calculation on a non numeric data. Please check you data.

Regards
Jay

raghu.chandra wrote:Hi All,

I am getting this warning message while running the datastage job.

"DataStage Job 2611 Phantom 16948
Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnumeric data when numeric required. Zero used.
Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnumeric data when numeric required. Zero used."

Please help me to resolve this.
No oracle stage is used in the job.

Thanks
Raghu

Have you looked at/near line 906 in the 'program' mentioned? It should give you a clue as to the where / why of the problem.

Knowledge of your job design should help.
Make sure your metadata is correct and no varchar field goes to any kind of numeric field.

... or is used in any arithmetic operation or function.