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

[David & Eileen Keck <bstars@xxxxxxxxxxxxx>]

This looks like a classic square peg round hole problem.  Never mind with
the SQL.  Add a new field to your file.
-Dave K.
----- Original Message -----
From: "Jim Franz" <franz400@triad.rr.com>
To: <midrange-l@midrange.com>
Sent: Sunday, January 13, 2002 11:19 AM
Subject: Re: sql help-select sum of 2 fields in flat file


> this sql is in a rpg inquiry program over ar invoice file. The problem is
> performance. Over a million record file, so I can't read all records,
> summing the 2 fields in each record. Have been doing the rpgsql for about
5
> years, just can't figure this complex a statement yet.
> Loyd gave me something to try monday (see his prev post)
> Am replacing a current rpg screen that does read all million records, in
> 5-15 minutes, killing system performance. Sql looks like a good fit here
if
> I can get this problem solved.