Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Match one file with two other file and write in output file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Rjadeja

New User


Joined: 18 Feb 2008
Posts: 9
Location: Mumbai

PostPosted: Sat Mar 12, 2011 10:15 am    Post subject: Match one file with two other file and write in output file
Reply with quote

Hi All,

I have threee input files callled A,B,C and output file D and wanted to match on basis of field called NUMBER. All files are sorted on NUMBER field.

If record of file A matches with B or C wrtie record in file D.

Can you please suggest how to do this.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 12, 2011 10:34 am    Post subject:
Reply with quote

Hello,

Depending on how much experience you have, you could write a 3-file match/merge using the A file as the driving file.

If your experience is somewhat limited, you could consider combining the B and C files and cloning the 2-file match/merge tested sample code that is an attachment to the "Sticky" near the top of this COBOL part of the forum.
Back to top
View user's profile Send private message
Rjadeja

New User


Joined: 18 Feb 2008
Posts: 9
Location: Mumbai

PostPosted: Sat Mar 12, 2011 10:43 am    Post subject:
Reply with quote

Thanks a lot. I was not thinking in that and trying to compare one file with two files. I got it your point. Thanks for your help and quick response
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 12, 2011 11:12 am    Post subject: Reply to: Match one file with two other file and write in ou
Reply with quote

You're welcome - good luck icon_smile.gif

Someone will be here if there are questions/problems.

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 5 Wed Jul 26, 2017 7:35 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us