2-File Match/Merge sample code

dick scherrer · Posted: Tue Jul 10, 2007 9:12 pm Post subject: 2-File Match/Merge sample code

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: 34 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: 34 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 · New User Joined: 03 Mar 2008 Posts: 3 Location: Portugal

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,