Write match & mismatch recs

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi,

I have 2 files( FileA & FileB) and 2 output files(Filec & FileD).

I have to write all the matching records from File A & File B to File C.
I have to write all the records from File A to File D which are not matcing with File B.

Is it possible to do the above logic in SORT?

Thanks & Regards
Prabs

Frank Yaeger · Posted: Mon Mar 20, 2006 10:11 pm

You can use a variation of one of the jobs shown in the Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05

muffirulz · Posted: Mon Mar 20, 2006 10:16 pm

hi frank,

Can you tell me a way to use sort for the above problem because I am also facing the same problem

Thanks

Frank Yaeger · Posted: Mon Mar 20, 2006 10:22 pm

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi Frank,

I tried it but somehow Iam not getting the correct result.
The problem is Syncsort is installed in my mainframes. The Job does run correctly but not the result.

My Q is it the problem of not having DFSORT or something elz?\

T & R
Prabs

Frank Yaeger · Posted: Tue Mar 21, 2006 9:13 pm

The jobs shown in that Smart DFSORT Trick run fine with DFSORT.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Thats ok.fine..Thanks a lot

sril.krishy · Posted: Wed Mar 22, 2006 11:59 am

Hi,
If your shop is having the latest release of SYNCSORT,You can use the JOIN KEYS feature to get the required o/p files easily.

Please check the SYNCSORT version in your shop.

Thank you
Kris