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

comparing two files using Sort


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Pavani G

New User


Joined: 21 Apr 2010
Posts: 10
Location: Hydearabad

PostPosted: Fri May 14, 2010 2:52 pm
Reply with quote

Hi,
I have two files. file1 has 100 records. file2 has 1000 records. Iwant to compare 3 fields of 17(int),4(INT),10(INT) bytes each record by record in two files and accumulate all the matched records into file3. the matched records should not be in file2.i.e, I want to have all the unmatched records in file2. Is there any way of doing this using DFSORT/ICETOOL??
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Fri May 14, 2010 8:31 pm
Reply with quote

Hello,

Show some sample input from both files and the output you want from the sample input.

Mention the dsorg and lrecl of all files. Post the rules for getting from the sample input to the sample output.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
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 JCL sort card - get first day and las... JCL & VSAM 9
Search our Forums:

Back to Top