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
 

 

MERGE Using FILEAID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: MERGE Using FILEAID
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: 356
Location: New York

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

You can refer the following link.

http://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    Post subject:
Reply with quote

ksk wrote:
You can refer the following link.

http://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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm
No new posts SQL Merge error -254 Robin Sulsona DB2 8 Wed Jun 01, 2016 8:28 pm
No new posts FileAid to compare(logical operations... anand1204 Compuware & Other Tools 3 Wed Apr 06, 2016 2:55 am
No new posts SAS MERGE to DFSORT Musab Ahmed DFSORT/ICETOOL 6 Mon Feb 01, 2016 5:44 pm
No new posts Merge two files having two trailer re... R.Manivannan DFSORT/ICETOOL 7 Wed Nov 25, 2015 9:18 pm


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