In your limited example, you show no duplicates within file1, no duplicates within file2, and no records in file1 that don't have a match in file2. I can give you a simple solution for that case, but I suspect you'll come back and say "but that didn't work for this other situation". So:
Joined: 21 Jul 2006 Posts: 49 Location: California
For all the Scenarios listed by Frank EZtreive will be a easy Solution.
Check with ur team if anyone is using EZtreive or search forum for more details.
In my previous Project I used for matching/unmatching records, I will try to get some samples.
This won't work since the data is alphanumeric. CH or BI would work. But again, this only works for the case where there are no dups within file1, no dups within file2 and no records in file1 that don't have a match in file2 which is what I was trying to verify.
//SYSOUT DD SYSOUT=*
This DD isn't needed and is ignored.
But I have a doubt if your i/p is typed wrongl
I agree. dddddeeeeff2 in file1 does not actually match dddddeeeee2 in file2, but was probably meant to.