Hi
I have 1 source seq file and 1 reference hash file.I am trying to join the two source files and trying to capture the rejected records from hash file
I was able to capture primary source unmatched records where as unable to capture reference file rejected records.
i.e i need to implement right outer join so that i can capture unmatched records from hash reference file
any one help me in this
Reference Hash file Rejects Capture
Moderators: chulett, rschirm, roy
Hashed files don't reject records in the way that you mean, nor does a hashed reference lookup support such a concept. All you can do is check to see if the lookup succeeded or not, typically via the NOTFOUND link variable.
If what you are after are the records in the hashed file that are not in your source data, you'll need to make a second pass and reverse the lookup.
If what you are after are the records in the hashed file that are not in your source data, you'll need to make a second pass and reverse the lookup.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hashed files usually aren't used at all in parallel jobs. Can you please provide more information about precisely what you're doing and what you hope to achieve?
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.