DataStage Job 2611 Phantom 16948

[raghu.chandra]

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

[Jayesh_09]

Raghu,

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

Regards
Jay

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

[chulett]

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.

[DSguru2B]

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

[ray.wurlod]

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