How to find out the duplicate records in two files?

eric · New User Joined: 28 Nov 2005 Posts: 3

Now, there are two qsam files with the same layout, I need to find out the duplicate records from the two files, could someone give me a sample?
It's highly appreciated.

k_vikram07 · New User Joined: 23 Nov 2005 Posts: 34

//sortin dd dsn=qsam1,disp=shr
// dd dsn=qsam2,disp=shr
//sortout dd dsn=temp,disp=(,catlg)
....
//sortxsum dd dsn=dups,disp=(,catlg)
//sysin dd *
sort fields=(your key def for finding duplicate)
sum fields=none,xsum
/*

This works if u use syncsort and want to find all duplicates of both files.

thanks
vik.

eric · New User Joined: 28 Nov 2005 Posts: 3

Vik,

Thanks for your help, however I haven't used the 'syncsort' and can't ensure the 'syncsort' is available in my environment, could you give me
a example for 'SORT'? That would be very appreciated.

Thanks
Eric

priyesh.agrawal

For DFSORT...

eric · New User Joined: 28 Nov 2005 Posts: 3

thanks a lot, I will give it a try!