hi All,
i am concatenating three columns and doing a look up on the concatenated column as a key on a an other concatenated column of a different table. i used the constraint
If IsNull(concatenated) then Not(rejected) Else rejected.
the look up is not done and there are '0' rows from the second table.
i am getting the following error.
DataStage Job 385 Phantom 9415
Program "JOB.711972817.DT.1353343954.TRANS1": Line 86, Variable "Pin%%V1S1P3.REJECTED" previously undefined. Zero used.
DataStage Phantom Finished
i would be greatly thankful for your suggestions or hints.
Thanks.
hashfile lookup
Moderators: chulett, rschirm, roy
-
Sainath.Srinivasan
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
First-of-all, you can use the NOTFOUND option for checking the success/failure of the lookup than using the IsNULL option.
Secondly, the error states that the job (no. 385) has some variable used without its declaration. You can see the line of usage in the file called TRANS1 under the job's directory.
Can you check whether you have any variable in any constraint not defined before.
Secondly, the error states that the job (no. 385) has some variable used without its declaration. You can see the line of usage in the file called TRANS1 under the job's directory.
Can you check whether you have any variable in any constraint not defined before.