Lookup stage and NVL function in SQL statement

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
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

Can you paste the exact query and the error you are getting here.... (as you said it is sparsed lookup, you must be passing a value from the mainstream record)
Top
kool78
Participant
Posts: 104
Joined: Sat Aug 20, 2005 2:02 pm

Post by kool78 »

Have u tried using Modify Stage: u can handle null values in tht stage(use handle_null function)
"Attitude always and almost determines the altitude of your Life"
Top
Post Reply

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