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

Compare 2 files with almost 6 million records in master file


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

New User


Joined: 20 Jun 2006
Posts: 9

PostPosted: Sun Apr 22, 2007 9:56 am
Reply with quote

Hi,

Can anyone help me with this?

Requirement:

I have 2 files:


Master file:

A123XXXXXXXXXXXX
A453FFFFFFFFFFFFFFFF
B123OOOOOOOOOOO
B456PPPPPPPPPPPPPP
C765BBBBBBBBBBBB
C321GGGGGGGGGGG



FILE2:
A123TTTTTTTTTTTTT
D432HHHHHHHHHHH
D123FGRDLLLLLLLLL


OUTPUT FILE SHOULS BE

A123TTTTTTTTTTTTT
A453FFFFFFFFFFFFFFF
B123OOOOOOOOOO
B456PPPPPPPPPPPPP
C765BBBBBBBBBBB
C321GGGGGGGGGG
D432HHHHHHHHHHH
D123FGRDLLLLLLLLL




RECORD LENGHT FOR BOTH FILES IS 43;
1 -4 COLUMNS ARE THE KEY FILEDS.


COMPARE THE 2 FILES;

FOR MATCHING KEYS, REPLACE THE RECORDS FROM FILE2.
FOR NON MATCHING KEYS IN MASTER FILE, RETAIN THE RECORD
FOR NON MATCHING KEYS IN FILE2, ADD THE RECORD TO MASTER FILES.

there will be almost 6 million records in master file and 2 million in file2.

Thank you.
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: Mon Apr 23, 2007 5:39 am
Reply with quote

Hello,

Have you looked at the Smart DFSORT Tricks paper at:
http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

If you look at the section on "Create files with matching and non-matching records", there is info that may help you.

If, after reading the "tricks", you have questions, please post what you want clarification about.
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
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 Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top