RE: SQL select into [array]?

Well it seems like if you need more than 7 columns you should set them all
up and them set the DIM (x) to the right number of amounts.



From:
"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
To:
"'RPG programming on the IBM i / System i'" <rpg400-l@xxxxxxxxxxxx>
Date:
08/27/2009 12:55 PM
Subject:
RE: SQL select into [array]?
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx

I'd simply the data structure definition as follows:

D Amounts_DS DS
D Amt01 7P 0
D Amt02 7P 0
D Amt03 7P 0
D Amt04 7P 0
D Amt05 7P 0
D Amt06 7P 0
D Amt07 7P 0
D AmtArray 7P 0 Overlay(Amounts_DS) Dim(7)

When I tried this at V5R4, SQL generated code that put the first seven
columns into AMT01-AMT07, and then an 8th column into AmtArray... which
set
all of AmtArray to the same value (zero) since a move to an array without
index is a move to all elements of the array (and then I got an error
about
wrong number of columns).


Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
... Had this been an actual emergency, we would have fled in terror, and
you
would not have been informed.