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

Write output from file1 if record from file2 is unmatched


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

New User


Joined: 22 Nov 2007
Posts: 83
Location: Chennai

PostPosted: Sun Jun 08, 2014 9:19 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10765
Location: italy

PostPosted: Sun Jun 08, 2014 9:48 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2632
Location: NYC,USA

PostPosted: Tue Jun 10, 2014 8:11 pm
Reply with quote

Please refer to the JOINKEY's examples from the below links and I am sure you will get the answer.

ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf
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 fetch the record number from FMNMAIN ... CLIST & REXX 10
No new posts Remove additional information in SUPE... TSO/ISPF 10
This topic is locked: you cannot edit posts or make replies. how to extract a portion (e.g. fields... SYNCSORT 8
This topic is locked: you cannot edit posts or make replies. Writng matched records into output fi... DFSORT/ICETOOL 11
No new posts Compare the file record count percent... DFSORT/ICETOOL 4
Search our Forums:

Back to Top