MVSFORUMS.com

reddysham4u · Beginner Joined: 06 Dec 2005 Posts: 4 Topics: 1

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

Phantom · Posted: Wed Dec 07, 2005 1:04 am Post subject:

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

reddysham4u · Beginner Joined: 06 Dec 2005 Posts: 4 Topics: 1

Thank u phantom,

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

Can u please help me

kolusu · Posted: Wed Dec 07, 2005 9:29 am Post subject:

reddysham4u,

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

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Phantom · Posted: Wed Dec 07, 2005 9:52 am Post subject:

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

reddysham4u · Beginner Joined: 06 Dec 2005 Posts: 4 Topics: 1

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.

kolusu · Posted: Wed Dec 07, 2005 10:33 am Post subject:

reddysham4u · Beginner Joined: 06 Dec 2005 Posts: 4 Topics: 1

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.

haatvedt · Posted: Sun Jan 15, 2006 3:08 am Post subject:

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)