View previous topic :: View next topic
|
Author |
Message |
lokesh_try8
New User
Joined: 30 Dec 2005 Posts: 14 Location: Chennai
|
|
|
|
Hi,
Our Requirement is to compare two PS files, which is sorted based on Key Field (Col 1 to 10). We need to compare these two files based on the key field. Is there any utility to compare using Key Fields? If so Kindly provide a sample JCL and reference documentation.
Thanks In Advance,
Lokesh |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
lokesh_try8 wrote: |
We need to compare these two files based on the key field. Is there any utility to compare using Key Fields? |
Yeah SORT can do this.. as suggested. But what exactly do you need in your output after comparison? |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
The SyncSort for z/OS JOIN feature can be used. But as Anuj pointed out, you did not explain exactly what you want in your output... please provide additional details. For example, do you want matched records, unmatched records, records reformatted with fields from both input files, etc.? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello Lokesh,
The way to get the most useful replies is to post representative sample input data for both files as well as the output you need from this input.
Also, please post the lrecl and recfm of the files. |
|
Back to top |
|
|
|