Re: RPG embedded SQL GROUP BY with cursor

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

When doing a group by, your field list has to have only the fields in 
the GROUP BY, as well as any aggregate fields, like SUM() or MIN() or 
COUNT()

SELECT * doesn't work.

On 1/13/2016 4:48 PM, Booth Martin wrote:
> My intention is to list transaction rows in order by item and then by 
> date, totaled by day. I would like to use a cursor.  Every variation I 
> can think of fails.  Here is where I am at:
>
>          exec sql declare C1 cursor for  // for Days
>            select *
>              from  FILEA
>              where ITEM = :wsqlITEM
>              group by ITEM, DATE
>              order by ITEM, DATE;
>
> Without the "group by" it works.  The result is a tad too many pages, 
> but it works.