Re: embedded SQL: group by rollup()

SELECT INTO only works when only a single row is returned.

Since you want three (or four) rows returned, you'll have to use a cursor.

Your code might compile, but if you run it you should get an error, SQL0811
- Result of SELECT more than one row.

Charles

On Mon, Jan 18, 2016 at 4:17 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

L1, L2, L3 are values to be found in LOC.

I am attempting to total the ORD column, by LOCation. I want the total
order quantity for each of 3 warehouse LOCations.

I had originally used a cursor. The examples I found appeared to not use
a cursor, so I took it out.

Yes, I agree. I am putting all the values in one bucket. Thats not
right, but every thing else I have tried so far is even less right. I
haven't yet found an example that is complete from end to end.

On 1/18/2016 3:02 PM, Michael Schutte wrote:

are L1, L2 and L3 fields in FILEA?

If so add them to the Select and group by....

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