MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Matching 2 files and creating 3rd file using Fileaid

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
reddysham4u
Beginner


Joined: 06 Dec 2005
Posts: 4
Topics: 1

PostPosted: Tue Dec 06, 2005 6:07 pm    Post subject: Matching 2 files and creating 3rd file using Fileaid Reply with quote

Hi,

I need a help in File Aid.
I have 2 files File1, file2.
File1 cintains Empnumber,name
File2 contains Empnumber,Address
I need to create file3, such that File3 should contain EmpNumber,Name,Address for each entry of File1.
Can you please post batch JCL for the above problem.
Can anybody please help me.
Its urgent.

Thanks in Advance

Shyam
Back to top
View user's profile Send private message
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Wed Dec 07, 2005 1:04 am    Post subject: Reply with quote

Shyam,

I am not good at File-Aid, but you can do this easily using Sort. if you are interested in SORT, check the following links.

http://www.mvsforums.com/helpboards/viewtopic.php?t=680&highlight=duplicate+splice
http://mvsforums.com/helpboards/viewtopic.php?t=4838&highlight=match+sort
http://mvsforums.com/helpboards/viewtopic.php?t=11&highlight=match+sort
http://www.mvsforums.com/helpboards/viewtopic.php?t=2951&highlight=duplicate+splice

Hope this helps,

Cheers,
Phantom
Back to top
View user's profile Send private message
reddysham4u
Beginner


Joined: 06 Dec 2005
Posts: 4
Topics: 1

PostPosted: Wed Dec 07, 2005 9:26 am    Post subject: Reply with quote

Thank u phantom,

But i need a FileAid Batch JCL.
For this i need to Merge two files....

Can u please help me
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Wed Dec 07, 2005 9:29 am    Post subject: Reply with quote

reddysham4u,

File-aid does not have the ability to do what you asked for.

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Wed Dec 07, 2005 9:52 am    Post subject: Reply with quote

reddysham4u,

May we know why you are looking only for a file-aid solution ? Was that given as your project requirement ?

If not, would you be interested in any other solutions like Easytrieve / cobol...

Thanks,
Phantom
Back to top
View user's profile Send private message
reddysham4u
Beginner


Joined: 06 Dec 2005
Posts: 4
Topics: 1

PostPosted: Wed Dec 07, 2005 10:21 am    Post subject: Reply with quote

I think we can use COPY,REPL,USER,EDIT,WRITE,UPDATE ...etc functions to merge the files in File Aid batch JCL.

Ex:

$$DD01 COPY IF=(.....),OUT=...,
$$DD01 USER WRITE= file1, IF=(....),MOVE=(..),WRITE=file1

Imagine...

The file structure is as follows

File1

----+----1----+----2----+----3
Emp Number EmpName


File2

----+----1----+----2----+----3
Emp Number EmpAddress


Can u please provide a file merge Batch JCL for fileAid.
such that file3 should contain Empnumber,Empname,EmpAddress.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Wed Dec 07, 2005 10:33 am    Post subject: Reply with quote

Quote:

I think we can use COPY,REPL,USER,EDIT,WRITE,UPDATE ...etc functions to merge the files in File Aid batch JCL.


reddysham4u,

If you think you can solve it using those features then why not code the solution and show it to us, so that we can also learn.

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
reddysham4u
Beginner


Joined: 06 Dec 2005
Posts: 4
Topics: 1

PostPosted: Wed Dec 07, 2005 10:59 am    Post subject: Reply with quote

I just started learning FileAid to solve this problem.
If i solve, i will definitely show it tou.
But i thought, there are many senior professionals who worked in FileAid will help me.
Becaz just to solve this, i am reading all the docs and trying for solutions.
It would be great, If any one can help me.
Back to top
View user's profile Send private message
haatvedt
Beginner


Joined: 14 Nov 2003
Posts: 66
Topics: 0
Location: St Cloud, Minnesota USA

PostPosted: Sun Jan 15, 2006 3:08 am    Post subject: Reply with quote

I have been using File-Aid for about 28 years. Back then it was called DUMPER, written by J.R. Blank if my memory serves me right. I suspect that if I absolutely needed to use File-Aid and SORT to solve this problem, that I could do it.

However, different tools each have thier own strengths. If I could choose the tool for this I would use either COBOL or CA-EasyTrieve. COBOL would take a bit longer to write, but from a debugging standpoint its supported by dump analysis tools from multiple vendors.

Chuck Haatvedt

ps... FileAid is one of my favorite tools, I think I cried for months when my employer removed it. Thankfully, they reconsidered and we have it back again. Very Happy
_________________
Chuck Haatvedt

email --> clastnameatcharterdotnet

(replace lastname, at, dot with appropriate
characters)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group