Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need a utility for comparing 2 files and create 2 files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 69
Location: India

PostPosted: Mon May 19, 2014 3:58 pm    Post subject: Need a utility for comparing 2 files and create 2 files
Reply with quote

Hi,
I have VSAM files with the same Lrecl and keylength.

Can we have a utility or REXX ( not a cobol program) through which we can compare the files and create 2 output files with same lrecl and record position with the below requirement-

1. Output file1 - Contain data which contains records which are only present in new file

2. Output file 2 - Contain data which contains records which are only present in old file

3. Please note that most of the records will be common in both the files. the files contains around 1 million records.

I know that i can compare 2 files using ISRSUPC utility but it does not display in the required format

Please help me!!
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Mon May 19, 2014 4:08 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

the problem has been posted and solved gazillions of times
by using the JOINKEYS clause of Your sort product

DFSORT is perfectly capable of handling VSAM input files

ICE messages indicate INM DFSORT
WER messages indicate SYNCSORT


anyway the preference for REXX rather than COBOL is a and choice for I/O Intensive processes

why not try to build inn the solution You developed for
http://www.ibmmainframes.com/viewtopic.php?t=62659&highlight=
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Mon May 19, 2014 4:14 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

Hello,

You can use JOINKEYS or SPLICE commands, to achieve the requirement.
Which SORT product are you using at your site; DFSORT or SYNCSORT; if you have DFSORT, please look up the DFSORT manual for these keywords, there are various examples present in the 'Smart DFSORT Tricks' manual for similar requirements, you can find DFSORT documentation at http://www.ibm.com/storage/dfsort; 'Smart DFSORT Tricks' manual at: ftp://ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Mon May 19, 2014 4:15 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

My bad, didn't notice Enrico had already posted the info.
Back to top
View user's profile Send private message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 69
Location: India

PostPosted: Mon May 19, 2014 4:30 pm    Post subject:
Reply with quote

Hi Abid,
I am using SYNCSORT.

Enrico,
Let me give it a try. thanks for your suggestions.
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Mon May 19, 2014 4:53 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

Hello,

JOINKEYS will work for you then.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Mon May 19, 2014 5:25 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

Quote:
JOINKEYS will work for you then.



for quite a bit of time JOINKEYS has worked for DFSORT also,
exactly from Nov, 2009 DFSORT PTF
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Mon May 19, 2014 5:34 pm    Post subject: Reply to: Need a utility for comparing 2 files and create 2
Reply with quote

Hello Enrico,

Yup, and thankfully has made our lives simpler in ways, for quite sometime icon_lol.gif
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us