RE: Loading arrayDS from sql select into statement?

Would be nice if you could use SELECT INTO along with FETCH FIRST XX
ROWS...

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles
Wilt
Sent: Monday, September 14, 2015 1:47 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Loading arrayDS from sql select into statement?

Always a good idea to fact check anything on the net...

The manual says: "The SELECT INTO statement produces a result table
consisting of at most one row, and assigns the values in that row to
variables."

SELECT INTO :MYDS is a commoning recommended solution. But there's no
array there.

Would be nice if you could use SELECT INTO along with FETCH FIRST XX
ROWS...

Charles

On Mon, Sep 14, 2015 at 1:33 PM, Koester, Michael <mkoester@xxxxxxxxxxxxx>
wrote:

Thanks Alan.
So the people on this list that have suggested to others that they use
a "select into :arrayDS" have never actually tried that?
My faith has been shaken.

Michael Koester

--