Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Is there any utility for comparing two different datasets(PS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
prasanth_urs

New User


Joined: 04 Dec 2006
Posts: 44
Location: Pune,India

PostPosted: Wed Apr 11, 2007 9:48 am    Post subject: Is there any utility for comparing two different datasets(PS
Reply with quote

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.
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Apr 11, 2007 9:55 am    Post subject:
Reply with quote

Hi Prashanth,

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

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

shows how to do it.
Back to top
View user's profile Send private message
vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Wed Apr 11, 2007 10:07 am    Post subject:
Reply with quote

Try this.

Code:
//STEP1  EXEC PGM=ICETOOL
//TOOLMSG  DD SYSOUT=*
//DFSMSG   DD SYSOUT=*
//IN       DD  *
111111111
222222222
333333333
444444444
555555555
666666666
777777777
888888888
999999999
//         DD  *
555555555
666666666
777777777
888888888
999999999
//OUT      DD  SYSOUT=*
//SORTXSUM DD  SYSOUT=*
//TOOLIN   DD *
  SELECT FROM(IN) TO(OUT) ON(1,9,CH) NODUPS DISCARD(SORTXSUM)
/*


OUT will have below the records which are non matching.
Code:
111111111
222222222
333333333
444444444


SORTXSUM will have below the records which are matching.

Code:
555555555
555555555
666666666
666666666
777777777
777777777
888888888
888888888
999999999
999999999
Back to top
View user's profile Send private message
prasanth_urs

New User


Joined: 04 Dec 2006
Posts: 44
Location: Pune,India

PostPosted: Wed Apr 11, 2007 3:56 pm    Post subject: Re: Is there any utility for comparing two different dataset
Reply with quote

ICETOOL is not working out for me...


Thanks,
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Apr 11, 2007 3:58 pm    Post subject:
Reply with quote

Can you post your ICETOOL con trol statements and output.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Apr 11, 2007 4:48 pm    Post subject: Re: Is there any utility for comparing two different dataset
Reply with quote

prasanth_urs wrote:
ICETOOL is not working out for me...
You might try SYNCTOOL, SORTXSUM is not a DFSORT parm but a Syncsort one.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Apr 11, 2007 4:54 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Apr 11, 2007 5:10 pm    Post subject:
Reply with quote

Good point expat....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us