Warning at the end of the job execution
Posted: Wed May 21, 2003 11:14 pm
Hi !
One of the job here gives a warning at the end of the execution.
Message is:
DataStage Job 54 Phantom 29394
Program "JOB.148334321.DT.1292550524.TRANS1": Line 680, Variable previously undefined. Zero length string used.
DataStage Phantom Finished
The job is composed of:
TRANSFORMER INPUT: 1 sequential file, 1 Hashed file (look-up);
TRANSFORMER;
TRANSFORMER OUTPUT: 2 sequential files and 1 ORABULK stage;
The problem probably comes form the data as this runs fine with some test input file but gives this warning sometimes with PROD input files.
Nothing special in &PH& repository.
I know there is a way to view the code generated by DS, but don't remember how. Can someone tell me?
If the warning message gives you some idea, please let me know too.
Thanks.
One of the job here gives a warning at the end of the execution.
Message is:
DataStage Job 54 Phantom 29394
Program "JOB.148334321.DT.1292550524.TRANS1": Line 680, Variable previously undefined. Zero length string used.
DataStage Phantom Finished
The job is composed of:
TRANSFORMER INPUT: 1 sequential file, 1 Hashed file (look-up);
TRANSFORMER;
TRANSFORMER OUTPUT: 2 sequential files and 1 ORABULK stage;
The problem probably comes form the data as this runs fine with some test input file but gives this warning sometimes with PROD input files.
Nothing special in &PH& repository.
I know there is a way to view the code generated by DS, but don't remember how. Can someone tell me?
If the warning message gives you some idea, please let me know too.
Thanks.