hashfile lookup
Posted: Tue Feb 01, 2005 10:50 am
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.
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.