More detail RE: Fast File Compare -- RPG400-L

Title: More detail RE: Fast File Compare

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

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
+---