RE: Fast File Compare

[eperozzi@xxxxxxxxxxx]

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 !

Are we sure is still "the most efficient way" ? (performance speaking)
>> I drought !

Can really SQL do the same ?
>> If yes then forget matching records !

Ain't  "matching record" going to be dropped all together with Primary file
support ?
>> ??

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