Page 1 of 1

Reference Hash file Rejects Capture

Posted: Mon Feb 08, 2010 12:43 am
by DSRajesh
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

Posted: Mon Feb 08, 2010 3:11 am
by DSRajesh
any one help here

Posted: Mon Feb 08, 2010 8:22 am
by chulett
Good Lord, have some patience. You posted in the middle of the night for a crap ton of people.

Posted: Mon Feb 08, 2010 8:53 am
by chulett
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.

Posted: Mon Feb 08, 2010 3:34 pm
by ray.wurlod
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?