I created an exception Hash file.
Loc_cd
Strt_tm
End_tm
I combined two tables, DB2 and hash file using a Loc_cd. During the join, it is possible that some codes on the DB2 table will not match the hash table. If there is no match I would like to pass a default strt_tm and End_tm that isn't in the hash file. Is there a way to do this.
Thanks
Hash File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Transformer stage detect whether the lookup succeeded (if not, LocCd from that link will be null) using If .. Then .. Else, and supply your default values in that expression.
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.