IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
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
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: 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 www.ibm.com/storage/dfsort; 'Smart DFSORT Tricks' manual at: 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: 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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts REASON 00D70014 in load utility DB2 6
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top