Is there any utility for comparing two different datasets(PS

prasanth_urs · Posted: Wed Apr 11, 2007 9:48 am

Hi all,

Please help me in this issue.

Is there any utility for comparing two different datasets(PS).

If A and B are two files , then i need to compare A with B and write the common records as well as the uncommon reocrds in C and D files.

Please provide me the syntax for this.

Thanks again.

guptae · Posted: Wed Apr 11, 2007 9:55 am

Hi Prashanth,

The "Create files with matching and non-matching records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

shows how to do it.

vkphani · New User Joined: 29 Oct 2003 Posts: 29

Try this.

prasanth_urs · Posted: Wed Apr 11, 2007 3:56 pm

ICETOOL is not working out for me...

Thanks,

expat · Posted: Wed Apr 11, 2007 3:58 pm

Can you post your ICETOOL con trol statements and output.

William Thompson · Posted: Wed Apr 11, 2007 4:48 pm

expat · Posted: Wed Apr 11, 2007 4:54 pm

The response posted by vkphani says that it uses ICETOOL, but I have learnt that PGM=ICETOOL can also invoke SYNCSORT / SYNCTOOL as well, obviously depending on the sort product installed.

From my view, SORTXSUM is just a DD name that has been used.

I guess if we do get around to seeing the output from the OP, we can see which tool is being used and offer help accordingly.

William Thompson · Posted: Wed Apr 11, 2007 5:10 pm

Good point expat....