RE: Compare Files/Records

John,
I recently finished a Y2K project where we compared files during the
remediation testing.  We found TAATOOL's CMPDBF utility to be more readable
than CMPPFM.  However, one cavet, and this may be true for any software, (I
would check the $5000 one) if one of your programs deletes a record or adds
a record and the parallel program does not, then neither tool will compare
the records beyond that in the file correctly since it is comparing by RRN.

Another idea, if you have the system resources, is to begin journaling on
all files, run a short series of tests and save the journal files after each
of these tests to DB files and compare the journals.  If both systems are
functioning the same, then the journals should be identical.  If not you
have detailed log of what changed, when and where.  You will probably want
to run short tests and delete the journals after each because journaling 500
files could eat up disk rapidly.  If this is a production environemnt, you
may be concerned about extra overhead journaling will take up.

Good Luck,
Sam Kanakanui
Borg Systems Inc.


-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Scott Mildenberger
Sent: Friday, September 10, 1999 2:41 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Compare Files/Records


TAATOOL has a utility called CMPDBF that may do what you want.  I seem to
remember using it several years ago.  You may want to check it out before
buying a product.

> -----Original Message-----
> From: John Hall [SMTP:jhall@hillmgt.com]
> Sent: Friday, September 10, 1999 10:49 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Compare Files/Records
>
> That sounds very interesting.  I am not sure if it fits in with what I
> need to do.
>
> It sounds like your utility finds the differences between two record
> formats.
>
> I have two files of identical record format.  One is being processed by
> our current production software at the same time the other with be
> processed by the new software.  Once both files have been processed I
> need to see which fields in which records are different.  This will
> highlight any differences in the software processing.
>
> Oh yeah - make that 2 sets of 500 files each that need to be compared !
>
> Right now I am looking at about $5000 for a product that appears to do
> the job very well !
>
>
> DTroesch@aol.com wrote:
> >
> > I am new to this list, so I hope that I get this right.  This is in
> reply to
> > the post from John Hall.
> >
> > I have a utility that I wrote to compare two files at the field level.
> It
> > lists fields that remain the same, the fields that changed, fields
> added, and
> > fields removed.  Also, has the option of creating calculations specs to
> write
> > a conversion program.
> >
> > If this could be of any help to you, I would be happy to share it.
> >
> > Deb Cook
> >
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---