View previous topic :: View next topic
|
Author |
Message |
drajagopal
New User
Joined: 20 Jun 2006 Posts: 9
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|