AW: SQL select into [array]?

It is not possible to fetch something directly into an array with embedded
SQL.
It seems also not to be possible to build a data structure and overlay it
with an array or define an array within a data structure.
The only way would be to fetch into a data structure and move this data
structure into an other that is overlayed by the array.

D MyDS E DS ExtName(MyFile)
D DSArr DS
D Array 10A Dim(10)

Exec SQL Select * into :MyDS from MyFile Where rrn=6;
DSArr = MyDS;
Dsply Array(1);

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von David FOXWELL
Gesendet: Thursday, 03. September 2009 14:37
An: RPG programming on the IBM i / System i
Betreff: RE: SQL select into [array]?

I'm sorry, I thought I was being clearer than I was.

I meant

CREATE TABLE MyArray AS
Select Field1, Field2, Field3

From *libl/MyTable

Then, I don't know exactly how you plan to use your array. If I wanted the
equivalent of MyArray(6), I could use SQL or a CHAIN operation.

Select * from MyArray where RRN(MyArray)=6

OR

CHAIN 6 MyArray

-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Dennis Lovelady
Envoyé : jeudi 3 septembre 2009 12:36
À : 'RPG programming on the IBM i / System i'
Objet : RE: SQL select into [array]?

Is there a reason why one could not use CREATE TABLE AS... and use
that table instead of the array?

________________________________
* Subject: SQL select into [array]?
* From: "Koester, Michael" <mkoester@xxxxxxxxxxxxx>
* Date: Thu, 27 Aug 2009 11:54:33 -0400

I am looking for an elegant way to code an embedded SQL

statement that

selects into, where the host target is an array.

Does that help with the question? What would the SQL SELECT
look like then?
How would the table be build? Maybe we should see a little
more detail about what follows "CREATE TABLE AS..." ?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"When I was a boy of fourteen, my father was so ignorant I
could hardly stand to have the old man around. But when I
got to twenty-one, I was astonished at how much he had
learned in seven years."
-- Mark Twain

--
This is the RPG programming on the IBM i / System i
(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.