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

["Jim Franz" <franz400@xxxxxxxxxxxx>]

its a software package - file changes are not "appreciated".
i also think sql is smarter than this.
jim

----- Original Message -----
From: "David & Eileen Keck" <bstars@optonline.net>
To: <midrange-l@midrange.com>
Sent: Sunday, January 13, 2002 3:40 PM
Subject: Re: sql help-select sum of 2 fields in flat file


> 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.
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>