Re: RPG embedded SQL GROUP BY with cursor

On Jan 13, 2016, at 5:48 PM, Booth Martin <booth@xxxxxxxxxxxx> 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.


--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.