Phantom 2844: Nonnumeric data when numeric required

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
branimir.kostic
Participant
Posts: 13
Joined: Thu Nov 04, 2004 4:30 am

Phantom 2844: Nonnumeric data when numeric required

Post by branimir.kostic »

Hello,

i got the following phantom-error message when started a job. I tried to figure out the problem but till yet i havent found any approach.

Can you help me? Where in my job is the mistake?

DataStage Job 516 Phantom 2844
Program "JOB.657285897.DT.1351835990.TRANS1": Line 598, Nonnumeric data when numeric required. Zero used.
Thank you for your help

Regards
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
covered before use search....
in short :
in your project directory inside the RT_BP516 you'll find a file named:JOB.657285897.DT.1351835990.TRANS1
inside it line 598 holds the actual assignment in question
look in the beginning of the code to resolve the %%.. to the actual column/variables in question as they apear in your job.
then you'll find the column that has none numeric data where numeric expected.
this is simply something you need to transform to a numeric value.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply