Re: RPG/SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Chuck

I think there are a couple typos in my reply - where I refer to tysales 
and lysales in the final SELECT. Check it out.

Vern

On 6/27/2012 12:00 PM, Graves, Chuck wrote:
> What type of select statement do I need to produce a data set containing:
>
> Customer#
> 2011 sales
> 2012 sales
>
> Generated from a file containing sales from several years.
>
> I am using this statement:
>
> exec SQL
>      declare stor_sls cursor for
>            select sdan8,
>                   sum(sdaexp/100)
>            from f4211l9
>            where sdivd>=:j_start and sdivd<=:j_end and
>                  sdlnty not in('T ', 'TN', '% ') and
>                  sdmcu=:mcu group by sdan8
>                     order by sum(sdaexp) desc;
>
> This statement produces what I want for the given date range..i.e.
>
> Customer#
> 2012 sales
>
>
> but I need a separate field for the prior years sales
>
> Do I declare a separate cursor for the prior year and then join the two???
>
> Thanks in advance...
> Chuck
>
>
>
>
>
>
> [Rodda Paint Turns 80!] Chuck Graves
>    Director of Information Systems
>    Rodda Paint Co.<http://www.roddapaint.com>
>    6107 N. Marine Drive
>    Portland, Oregon 97203
>    (503) 737-6042