Hi,
I am trying to do a lookup using a hash file..
I have ColA in seq file and ColA in Hash file(both files same structures)...I wanted to know how can I get a ColA data from hashfile if there is no match found in seq file but we have in hash file...(basically a outer Join)..
I tried to use merge stage, but having problems with It..Warning !!! "Construct Hash file failed"
Thanks
Join in hash file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Sun Jul 18, 2004 11:32 pm
-
- Charter Member
- Posts: 14
- Joined: Thu Dec 04, 2003 11:34 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not possible using a Hashed File stage. This uses the primary key, the whole primary key, and nothing but the primary key.
How would you do it if one table were Oracle and the other DB2? You can do the same with anything and a hashed file, if you access the hashed file via a UV stage.
How would you do it if one table were Oracle and the other DB2? You can do the same with anything and a hashed file, if you access the hashed file via a UV stage.
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.