Re: sum in SQL?

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.
>