Re: RPG embedded SQL GROUP BY with cursor

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.