IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Need a utility for comparing 2 files and create 2 files


 
IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 81
Location: India

PostPosted: Mon May 19, 2014 3:58 pm
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

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Mon May 19, 2014 4:08 pm
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
Use [URL] BBCode for Links
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 88
Location: India

PostPosted: Mon May 19, 2014 4:14 pm
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 Use [URL] BBCode for Links 'Smart DFSORT Tricks' manual at: Use [URL] BBCode for Links
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 88
Location: India

PostPosted: Mon May 19, 2014 4:15 pm
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: 81
Location: India

PostPosted: Mon May 19, 2014 4:30 pm
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: 88
Location: India

PostPosted: Mon May 19, 2014 4:53 pm
Reply with quote

Hello,

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

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Mon May 19, 2014 5:25 pm
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: 88
Location: India

PostPosted: Mon May 19, 2014 5:34 pm
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 All times are GMT + 6 Hours
Forum Index -> SYNCSORT
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts JOINKEYS to match two input files on ... DFSORT/ICETOOL 1
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Group comparison/update between two f... DFSORT/ICETOOL 10
No new posts Need assistance formatting when joini... SYNCSORT 8
No new posts Combining more 4 files with sorted or... DFSORT/ICETOOL 3

Back to Top