Re: Embedded SQL: appending a subsequent fetch to a host variable data structure

It surprises me what gems there are with SQL. Perhaps there is another one
I haven't found?

I have a cursor which fetches rows, up to 50 or so, and stores them in a
host variable data structure. The fetch happens several times, from 1 to
say, 40. I would like each subsequent fetch to append the fetched rows at
the end of the previous fetch. When done, I would like a single host
variable data structure with up to a thousand or so rows.

Is this reasonably possible?

--
Booth Martin
www.martinvt.com
(802)461-5349

It usually takes me more than three weeks to prepare a good impromptu
speech. -- Mark Twain
--
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.