Re: sum in SQL?

Paul,

if you're going that far, I would prefer to just use the embedded
SQL...



On Wed, 11 Dec 2002, Paul Nelson wrote:

> You need to check out SEQUEL from Advanced Systems Concepts
> www.asc-iseries.com
> Passing runtime variables is a piece of cake. If you want to be creative and
> do some editing, you wrap a CL program and prompt screen around the
> view/report. If you want some examples, let me know off list.
>
> Paul Nelson
> Arbor Solutions, Inc.
> 630-327-8665 Cell
> 708-923-7354 Home
> ----- Original Message -----
> From: "James Rich" <james@eaerich.com>
> To: <midrange-l@midrange.com>
> Sent: Tuesday, December 10, 2002 6:49 PM
> Subject: Re: sum in SQL?
>
>
> > On Tue, 10 Dec 2002, Peter Dow wrote:
> >
> > >     SELECT CUSTNBR, CUSTNAME, SUM(INVTOT), CUSTYTD
> > >       FROM CUSTOMERFILE JOIN INVOICEFILE ON CUSTNBR = INVCUSTNBR
> > >      WHERE INVMONTH = 12
> > >      GROUP BY CUSTNBR, CUSTNAME, CUSTYTD
> > >
> > > I'm assuming that CUSTYTD is a field in your CUSTOMERFILE.
> >
> > Excellent!  Good assumption, the YTD totals are in the customer file.
> > Here is what I used:
> >
> > select cmcst#6, cmcst#3, cmcsname, sum(ihinvtot), cmytdsal
> > from custmp, invchp where
> > cmcst#6=ihcst#6 and cmcst#3=ihcst#3 and ihinvdate>'2002-11-30'
> > group by cmcst#6, cmcst#3, cmcsname, cmytdsal
> >
> > Now I wonder how I can pass a date to this from say a CL program?  And
> > make it print instead of display?  I want to put this on a menu that
> > prints out the results for the current month.
> >
> > James Rich
> >
> > _______________________________________________
> > 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.
> >
>
> _______________________________________________
> 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.
>