Hi All,
The output of my lookup stage is Decimal(5) Null. Will DataStage not give output as Null when the lookup fails. It loads 0 instead.
Please confirm.
Thanks
Default Value for Decimal Lookup Output
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
It will use 0 if the field is non-nullable.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
I can't check right now, but on lookups I would think it returns NULL for nullable fields.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The value of target field depends on the nullability of reference field in lookup.
If the reference field in lookup is null then you you will get null in target field if there is no match.
If the reference field in lookup is not null then you will get zero in target integer field if there is no match.
If the reference field in lookup is null then you you will get null in target field if there is no match.
If the reference field in lookup is not null then you will get zero in target integer field if there is no match.
You are the creator of your destiny - Swami Vivekananda