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

MERGE Using FILEAID


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Anish M Soman

New User


Joined: 20 Oct 2008
Posts: 2
Location: Bangalore

PostPosted: Tue Jun 02, 2009 4:57 pm
Reply with quote

Hi,
I have two files A & B having same number of records.
A is having fields P,Q,R & S.
B is having fields P,T,U,V,,X,Y,Z.

I need to merge two files based on the field P in such a way that the fields in output will be P,Q,R,S,T,U,V,W,X,Y,Z.

Please let me know the method to do it using FILEAID.

Anish M Soman
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Tue Jun 02, 2009 5:51 pm
Reply with quote

You can refer the following link.

www.ibmmainframes.com/about13076.html
Back to top
View user's profile Send private message
Anish M Soman

New User


Joined: 20 Oct 2008
Posts: 2
Location: Bangalore

PostPosted: Tue Jun 02, 2009 6:18 pm
Reply with quote

ksk wrote:
You can refer the following link.

www.ibmmainframes.com/about13076.html


Hi ksk,

I've seen that post but there the requirement is to merge the single record in 'B' file to all input records from 'A' file.
Here its different. Here 'A' and 'B' will have a number of records.
What I need is to merge based on the particular filed 'P' which is common to both files.

Please advise if you have any ideas.
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 -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
This topic is locked: you cannot edit posts or make replies. Merge 2 input files based on the reco... JCL & VSAM 2
No new posts Merge 2 input files after sort SYNCSORT 14
No new posts Merge files with a key and insert a b... DFSORT/ICETOOL 6
Search our Forums:

Back to Top