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

Compare 2 files and write matching and unmatching record


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Ankurjain299

New User


Joined: 03 Feb 2007
Posts: 2
Location: india

PostPosted: Mon May 24, 2010 5:58 pm
Reply with quote

Hi,
Could any one please help in below requirement using DFSORT

I have two input file (lets say file A and file B) both of same record length of 120
Format of both the files is like this:

PLAN BRANCH GROUP ASSOC BRKIND SN SUBNAME

999 00 099930 001 783784 NICHOLAS
911 00 099180 001 134545 SABINE TH
911 00 099180 001 134545 SABINE TH
999 00 099280 001 134325 DONALD W.
935 00 099580 001 266555 NYSSA H.
900 00 099540 001 X 356565 AIMEE N.
900 00 099480 001 X 356546 DIANE L.
935 00 099950 001 3456234 DANA M. H
900 00 099940 001 4245455 JONNA R.
900 00 099940 001 4657777 CARLY M.
900 00 099480 001 4634664 DAVID T.

File A contains duplicate records

What i want is
1) Remove all the records in file A with GROUP 099940
2) Sort file A with respect to PLAN and GROUP
3) After that remove All the duplicates from file A
4) Sort File B with respect to PLAN and GROUP
5) Now compare file A and File B and all the matching record has to be written in File C of same format and all the unmatched records from both the file, in a different file


Thanks in advance
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon May 24, 2010 9:23 pm
Reply with quote

ankurjain299,

Please see the Smart DFSORT trick "Create files with matching and non-matching records" here

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top