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" <firstname.lastname@example.org> To: <email@example.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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.