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
 

 

Compare two PS using Key Fields

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
lokesh_try8

New User


Joined: 30 Dec 2005
Posts: 14
Location: Chennai

PostPosted: Thu Jan 24, 2008 2:55 pm    Post subject: Compare two PS using Key Fields
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 24, 2008 4:17 pm    Post subject: Re: Compare two PS using Key Fields
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Jan 24, 2008 11:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jan 25, 2008 12:41 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Sum Fields ballaswaroop DFSORT/ICETOOL 4 Tue May 02, 2017 11:07 am
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm
No new posts fuzzy compare Martylin JCL & VSAM 9 Thu Mar 30, 2017 2:45 pm


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