|
View previous topic :: View next topic
|
| Author |
Message |
Agni
New User
Joined: 22 Nov 2007
Posts: 83
Location: Chennai
|
|
|
|
Hi All,
I have two input files with account numbers (9 bytes). For example, file A is the master file and file B is deletion file. I have to compare file B against file A and if the account number from file B is matched with file A, then I need to omit those account numbers in the output file and write the output file from file A only if there is no matching account numbers with file B.
Example:
File A (Master file):
| Code: |
AAAAAAAAA
BBBBBBBBB
CCCCCCCCC
EEEEEEEEE
GGGGGGGGG
HHHHHHHHH
KKKKKKKKK
MMMMMMMMM
|
File B(deletion file):
| Code: |
BBBBBBBBB
HHHHHHHHH
KKKKKKKKK
|
Output file should have:
| Code: |
AAAAAAAAA
CCCCCCCCC
EEEEEEEEE
GGGGGGGGG
MMMMMMMMG
|
Please note that the input files are sorted already. File A is a VSAM KSDS file and file B is GDG version and output file should a flat file.
I tried searching in the forum but got a big list in the search result, can someone please help me on this?
Regards
Gopi |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
DFSORT is perfectly capable of processing VSAM KSDS
the fact that one of the files is a GDG generation ( NOT VERSION ) is completely irrelevant ..
being a GDG generation affects only the DATASET naming convent, retention and catalog mangement
THE CONTENT IS NOT AFFECTED ...
remember that a SORT application ALWAYS create a new dataset ,
usually a VSAM KSKD dataset name is something a bit more static
anyway look at any JOINKEYS examples in the forums
keeping/excluding the records that are/are not in the other file |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
|
|
