|
You could try one SQL that seeks to read only ONE field ... get the TOTAL of * all the million + records, and a separate SQL to read the total of the other one field, then add the two in RPG. In my opinion, when RPG reads an entire record of a file, there is a hit based on the size of the record, especially when the program only needs a very few fields of the file. This is one of the advantages of SQL ... you only access the fields you need. MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
As an Amazon Associate we earn from qualifying purchases.
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.