Phantom Rows

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
asitagrawal
Premium Member
Premium Member
Posts: 273
Joined: Wed Oct 18, 2006 12:20 pm
Location: Porto

Phantom Rows

Post by asitagrawal »

Hi,
My Job is giving the below error:
DataStage Job 178 Phantom 2772
Program "DSD.StageRun": Line 617, Nonnumeric data when numeric required. Zero used.

I read in the prev posts and chechked in the JOB.1638052153.DT.1419972357.TRANS1 file, but to my wonder the file has just 610 lines and as per the earlier posts, I shud be able to locate a pc of code on the line number 617!

Plz suggest sth.
Thx
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You will notice within the generated code some $INCLUDE statements. The line numbers in the diagnosis count the lines in the included files. That's why there is a discrepancy.

However, you ought not need to inspect the code to resolve this error. You have tried to effect some numeric operation (arithmetic or numeric function) but your data have contained a non-numeric value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply