DataStage Job 62 Phantom 27651

[nchincholikar]

Hi Everybody,
can anybody tell me why I'm getting this error ?

DataStage Job 62 Phantom 27651
Program "JOB.656555515.DT.1362481236.TRANS1": Line 187, Nonnumeric data when numeric required. Zero used.


Thanks in Advance,
Narendra

[sudharsanan]

Hi Narendra,

From the Error Message

"DataStage Job 62 Phantom 27651
Program "JOB.656555515.DT.1362481236.TRANS1": Line 187, Nonnumeric data when numeric required. Zero used. "

It shows that your using a Non-numberic data when Numeric is requried.. have you checked the data.. was there any non-numeric data present in the input.. also while posting please give us some more inputs about what you are doing in this job.. wht is the source and wht is the transoformation and the target.. so that we can understand your problem?..please provide some more info about the issue...

[Sainath.Srinivasan]

In your project, you will find the dir called RT_BP62 and a file called JOB.656555515.DT.1362481236.TRANS1 under it. Line 187 in this file has the command / action that raises this error. You may have to check +/- 5 lines to locate the exact line.

General causes are initialisation of your staging variables.

[kollurianu]

Hi Sainath,


Where is this dierectory RT_BP62 found ? what does this RT_BP62 indicate?

Thank you very much,

[ArndW]

The directory RT_BP62 will exist in Narendra's account but might not exist in yours (as you create new jobs the number gets incremented). The RT_BP subdirectory is underneath the project directory; it contains the generated BP (Basic Program) code from DataStage.

[rgandra]

Narendra,

Check the if and else staments in the transformer. I think, somewhere you are missing else clause.

Check the first tranformer in your job as mentioned in the error. If you are not using if else clauses let me know what ru doing.


-sandeep

[kollurianu]

Thank you very much Arnd. :D