Re: More detail RE: Fast File Compare

>>> "Hatzenbeler, Tim" <thatzenbeler@clinitech.net> 11/14/00 12:41:56 PM >>>
Actually its an application that needs to be ran daily.

What I have is a one of our Inventory systems is running on a PC.  But the
auditing facility on the PC software is very weak.  So what I wanted to do
was download the whole inventory file every night, and compare it with the
previous days download (image) and match up each corresponding item and see
if any records had been changed, and kick an exception report so our
accountants can account for them.   

99% percent of our inventory is on the as/400 except for this one piece,
because it a specialized application...  So everynight, I read all the data,
and create records into our as/400 Materials Management system...  But it's
only about 97% reliable, so this is why I have now decided to take the whole
inventory file each night, and match the integrity of the data... 

And since it will run every night, I was hoping to program it in an a
efficient way...

And right now its' via using the prefix command and the externally defined
data structures, with a compare at the datastructure level...

I was wondering if using the eval was the quickest way or should I use some
type of pointer to compare the locations in memory?

Or if there was a faster way, because this file will only get bigger...  And
the PC software will let them change and record no matter how old it is,
with no way of telling me about the change.

tim

> -----Original Message-----
> From: Richard Jackson [SMTP:richardjackson@richardjackson.net] 
> Sent: Tuesday, November 14, 2000 4:18 AM
> To:   RPG400-L@midrange.com 
> Subject:      RE: Fast File Compare
> 
> -|-----Original Message-----
> -|From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On 
> -|Behalf Of eperozzi@teamlab.com 
> -|Sent: Tuesday, November 14, 2000 2:42 AM
> -|To: RPG400-L@midrange.com 
> -|Subject: RE: Fast File Compare
> -|
> -|
> -|
> -|Hello All !
> -|
> -|Few questions & and my humble opinion:
> -|
> -|How many programmers are still around that know how to write a matching
> -|record program....?
> -|>> I forgot !
> 
> I do ... :)
> 
> -|Are we sure is still "the most efficient way" ? (performance speaking)
> -|>> I drought !
> 
> There is no notably more-efficient algorithm.  Implementations may vary.
> 
> -|Can really SQL do the same ?
> -|>> If yes then forget matching records !
> 
> SQL can do it.
> 
> -|Ain't  "matching record" going to be dropped all together with
> -|Primary file
> -|support ?
> -|>> ??
> 
> Who cares.  isn't this a one-time project?
> 
> -|euro perozzi
> -|
> -|
> -|
> -|
> -|
> -|                    "Nick Runnalls"
> -|
> -|                    <nick_runnalls@hawkb        To:
> -|<RPG400-L@midrange.com>
> -|                    ridge.com>                  cc:
> -|
> -|                    Sent by:                    Subject:     RE:
> -|Fast File Compare
> -|                    owner-rpg400-l@midra 
> -|
> -|                    nge.com
> -|
> -|
> -|
> -|
> -|
> -|                    11/14/00 05:12 AM
> -|
> -|                    Please respond to
> -|
> -|                    RPG400-L
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|If you need to write a program Matching record processing will do the
> job,
> -|it is by far the most efficient, look it up in the RPG Manual, otherwise
> -|use CMPPFM
> -|     -----Original Message-----
> -|     From: owner-rpg400-l@midrange.com 
> -|[mailto:owner-rpg400-l@midrange.com] 
> -|     On Behalf Of Hatzenbeler, Tim
> -|     Sent: Tuesday, 14 November 2000 9:41 AM
> -|     To: 'RPG400-L@midrange.com' 
> -|     Subject: Fast File Compare
> -|
> -|
> -|
> -|     I have 2 large files, with about 15 fields in each record.  These 2
> -|     file have the same fields.  I want to test these 2 files a
> -|record at a
> -|     time to verify data integrity.
> -|
> -|
> -|     My question is this,  what's the fastest way to compare these
> files.
> -|
> -|
> -|     I was going to read the (driver file) a record at a time,
> -|and chain to
> -|     the equivalent record in the other file.  and compare the records
> by
> -|     comparing data structures that include the names of the all
> -|the fields
> -|     in the 2 files.
> -|
> -|
> -|     is there a better/faster way?
> -|
> -|
> -|     Thanks, tim
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|
> -|+---
> -|| This is the RPG/400 Mailing List!
> -|| To submit a new message, send your mail to RPG400-L@midrange.com.
> -|| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> -|| To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> -|| Questions should be directed to the list owner/operator:
> -|david@midrange.com 
> -|+---
> 
> 
> 
> Richard Jackson
> Richard Jackson and Associates Ltd.
> IBM Business Partner
> mailto:richardjackson@richardjackson.net 
> http://www.richardjacksonltd.com 
> Telephone: 1 (303) 808-8058
> 
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com 
> +---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---