Can anyone exlain me on conditional lookup??? And how it can be achieved thro DataStage V6?
Thanks,
Bala
Conditional Look up
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I understand (without having had the opportunity to "play" yet) that conditional lookup is only available in mainframe jobs in DataStage 6.0. It's only available in the Lookup stage type.
You specify a "pre lookup condition", an "action if pre lookup condition fails" and an "action if lookup condition fails".
Each action may be one of "any", "skip row", "null fill", "use previous value" (pre), or "abort program" (after).
For more information consult the DataStage XE/390 Job Developer's Guide (MainFrame.pdf) in your DataStage 6.0 manual set (it's on your CD and may be installed with your DataStage client software).
You specify a "pre lookup condition", an "action if pre lookup condition fails" and an "action if lookup condition fails".
Each action may be one of "any", "skip row", "null fill", "use previous value" (pre), or "abort program" (after).
For more information consult the DataStage XE/390 Job Developer's Guide (MainFrame.pdf) in your DataStage 6.0 manual set (it's on your CD and may be installed with your DataStage client software).