Hi,
In the lookup stage I have 4 options if the lookup is not found. The options are 1. Continue 2. Abort 3. Reject and 4. Drop.
If I use the first option and say to continue a null will be passed to the output....
The null values dipend on the column lookup format?
Because If the lookup column are not nullable and lookup not match I have an error in my job,
Why??
Thanks in advance
nullable fields in lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the lookup field is nullable AND the output field is nullable (and the rule is "Continue"), then you will get null. You will need to handle this null further downstream in your job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.