Re: sql help-select sum of 2 fields in flat file

[MacWheel99@xxxxxxx]

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)