View previous topic :: View next topic
|
Author |
Message |
sandeep kumar302
New User
Joined: 14 Mar 2012 Posts: 81 Location: India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
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 |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
My bad, didn't notice Enrico had already posted the info. |
|
Back to top |
|
|
sandeep kumar302
New User
Joined: 14 Mar 2012 Posts: 81 Location: India
|
|
|
|
Hi Abid,
I am using SYNCSORT.
Enrico,
Let me give it a try. thanks for your suggestions. |
|
Back to top |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
Hello,
JOINKEYS will work for you then. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
Hello Enrico,
Yup, and thankfully has made our lives simpler in ways, for quite sometime |
|
Back to top |
|
|
|