Datastage Warning....

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
akhila.chitti
Participant
Posts: 6
Joined: Fri Jul 06, 2007 3:10 am

Datastage Warning....

Post by akhila.chitti »

Hello,

I am trying to run a load job and the following is the Phantom error that I get:

DataStage Job 920 Phantom 24848
Program "JOB.208035487.DT.1458444514.TRANS1": Line 122, Nonnumeric data when numeric required. Zero used.

Could you please let me know what this means and help me to proceed with the run without warnings?

Thanks in advance,
Akhila.
Akhila Chitti
Software Engineer
HSBC, GLT.
Hyd.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

There's a column in the Transformer that has math operations and a non-numeric value is coming thru. You need to find it and deal with the non-numeric data.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio

Post by Krazykoolrohit »

you have posted the same query twice in parallel forum and once in server forum on the same day.

Creating a number of threads doesnt guarantee answers. it only contributes to spamming.
Post Reply