Lookup Stage

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
waitnsee
Participant
Posts: 23
Joined: Tue Jul 06, 2004 10:20 am

Lookup Stage

Post by waitnsee »

I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence number which is generated by the system and there is no way of finding a NULL.
Can anyone of you explain me how to rectify that.
Thank you.
Top
pavankvk
Participant
Posts: 202
Joined: Thu Dec 04, 2003 7:54 am

Re: Lookup Stage

Post by pavankvk »

can you post the error message??
waitnsee wrote:I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence number which is generated by the system and there is no way of finding a NULL.
Can anyone of you explain me how to rectify that.
Thank you.
Top
kjanes
Participant
Posts: 144
Joined: Wed Nov 06, 2002 2:16 pm

Post by kjanes »

I didn't get a good feel for what your scenario is. Are the key columns for your source and lookup "nullable=no" before, during, and after the lookup?
Kevin Janes
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”