Program to matches/merges two sequential files

dick scherrer

Hello,

Attached to this "sticky" is a small sample program that matches/merges 2 sequential files that have been previously put "in sequence".

Depending on your exact requirement, changes may need to be made, but the overall process works for most cases. If your files have a 1-to-1 or a 1-to-many relationship, the model should work for you. One case where additional code may be needed is when both files might have duplicate key values. The issue may be how to determine how the duplicates should "sync up".

Something to keep in mind is that to keep things more manageable you do not want to code compares for multiple keys. As you read records (before any comparing) combine the "key" fields into a ws field (one for each file) so the compare does not become other than simple.

If you find a typo or a "real" error, please let me know via PM. If you prefer a different way, fine, but this is an approach that works many, many places.

I cannot emphasize enough that it is critical that you thoroughly test your version of the code before production implementation.

Purnendu.it · New User Joined: 11 May 2007 Posts: 59 Location: chennai

Hi dick,
I want to inform you that the code you have is not coming in proper alignment after download.
Please can you send it in a proper alignment

Thanks in advance,
Purnendu.

CICS Guy · Posted: Wed Sep 19, 2007 3:47 pm Post subject:

I sometimes find that if you just save the unopened file to your PC before opening it, everything will align properly....Something about how the browser sees a txt file and how notepad sees that same file....

dick scherrer · Posted: Wed Sep 19, 2007 8:32 pm Post subject:

Hello Purnendu,

As CG suggests, saving the file to your local drive will "clean it up".

Many of the attached text files do not open properly in browser windows.

Please let us know if it doesn't open properly after you right-click/save as.

Purnendu.it · New User Joined: 11 May 2007 Posts: 59 Location: chennai

HI dick,
Yes its working properly.When i was downloading it was
having improper alignment but after i tried as you suggested its perfectly
alright.

Thanks

dick scherrer · Posted: Thu Sep 20, 2007 7:37 pm Post subject:

You're welcome

Thanks for letting us know that it worked for you.

hanucob · New User Joined: 15 Jul 2008 Posts: 4 Location: bangalore

I your file is not ease for use ...its in irregular format after down loading,
please send it in correct way

dick scherrer · Posted: Wed Jul 16, 2008 8:00 pm Post subject:

Hello Hanu,

Please re-read the replies to this topic.

The file is easy to use if you follow the directions. . .
From earlier. . .

ntmartins · Posted: Fri Jul 18, 2008 8:48 pm Post subject: Structured programing

Hi,

Think this sample program will be usefull to less experienced programmers.

But it does not meet most companys standards. Usage of "GO TO", for instance, instruction is not accepted in many companys.

Any way, thanks.

dick scherrer · Posted: Fri Jul 18, 2008 9:04 pm Post subject:

Hello,

rbi · New User Joined: 25 Sep 2008 Posts: 3 Location: NC

Hi,

How do I get the attached file? I can't seem to find it.

Thanks

rbi · New User Joined: 25 Sep 2008 Posts: 3 Location: NC

Hi,

Don't worry about, I've found it.

thanks again.

dick scherrer · Posted: Wed Oct 01, 2008 8:57 pm Post subject:

Hello and welcome to the forums,

rbi · New User Joined: 25 Sep 2008 Posts: 3 Location: NC

Hi,

The code is simple, yet effective. And I agree, GO TO statement is not to be dreaded upon. Most of the time (if used properly) it yields much better performance compared to PERFORM.

Thanks,
rbi

dick scherrer · Posted: Thu May 14, 2009 7:24 pm Post subject:

Hello,

Right-click (Save Target As) on the DOWNLOAD link on the right-side of the attachment.

This will create a text file on your pc. Upload the code to the mainframe, make changes for your specifics and run a test.

Any problems, post back here.

If you had read the topic, you would have saved yourself some time as this has been posted multiple times (in this same topic) because of others who did not read. . .

sunitatprasad · New User Joined: 18 May 2006 Posts: 9

Hi,

I couldn't find the attachment.

Thanks,
Sunita

Arun Raj · Posted: Mon Jun 08, 2009 12:43 pm Post subject:

Hello,

Did you follow the steps mentioned by dick above? Are you getting any error?

sunitatprasad · New User Joined: 18 May 2006 Posts: 9

Hi,

After posting the reply I'm able to see the attachment.

I downloaded it also.

Thanks,
Sunita

rakam.kishore · New User Joined: 28 Mar 2008 Posts: 1 Location: hyderabad

thanq-

dick scherrer

You're welcome - good luck

Someone will be here if there are questions,

d