RE: Fast File Compare -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Title: Fast File Compare

You can use the exception join functionality in SQL to print out the records that are different. Join all the fields to all the fields and print the differences.

Richard Jackson
Richard Jackson and Associates Ltd.
IBM Business Partner
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Telephone: 1 (303) 808-8058

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On Behalf Of Hatzenbeler, Tim
Sent: Monday, November 13, 2000 6:41 PM
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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.