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 All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts FileAid move data from two files to o... Compuware & Other Tools 5
No new posts JCL to merge two files side by side DFSORT/ICETOOL 3
No new posts One to Many merge SYNCSORT 7
No new posts SORT JCL to merge multiple tow into s... DFSORT/ICETOOL 6
No new posts Search two or more word with FILEAID Compuware & Other Tools 17
Search our Forums:


Back to Top