Re: looking for recommendations for iSeries file comparison utility...

During a conversion we used FILE TRACK.
Our usage was in jigasaw puzzle of combining pieces of information from different files into new file.
However, you'd probably need to be able to make an external file definition on the internally described file.

I do not know the correct terminology for something.
I call it an UNJOIN or UNMATCH
You can list records in one file that have no match in another file.
You have to do it both ways.
List records in file A that have no match in file B.
List records in file B that have no match in file A.
Best way to do this is probably SQL embedded in RPG.
On large files if you do it with Query/400, the system will take a very severe performance hit.

When you are in work with members with PDM you can use option 54 to compare any two members ... source code, physical files, other objects.
It will identify what's different between the two members on a row by row basis.

I use it a lot for comparing two versions of some program, but it also works for a host of other types of IBM objects. This is same thing other people are calling CMPPFM

In addition to the limitations other people stated, it can generate excess information.
Suppose you have inserted records.
You can get a jumbled story where it is comparing line for line, and now you are offset by the number of inserted or deleted records.

List,

We are in need of a file comparison utility that executes on the iSeries. It
will need to be able to compare both externally and internally described
(sequential "flat") files. It should be able to handle files of any size --
from hundreds or thousands of records to millions of records.

Any recommendations? TIA!

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC 27101
336-761-1524
m rosinger at cciws dot com


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.