Hi
I am just doing a normal lookup from data set file..
I noticed that data stage is inserting Zero value for null fields after lookup. I saw the value in peek stage and datatype is Integer ,,,
I just want to confirm is this is true,,,
please confim
thks
Default to Zero after lookup for Null feilds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
True? We can only choose to believe what you told us.
Check your job log for warnings, and check null field value in the target stage. Check, too, that the output column is marked as nullable.
Check your job log for warnings, and check null field value in the target stage. Check, too, that the output column is marked as nullable.
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.