× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi David

Could be done, but then you have to read the target file, too, where with an array, the reads are done and you just use the value.

Vern

David FOXWELL wrote:
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.

As in:

Select Field1, Field2, Field3
into :MyArray(1), :MyArray(2), :MyArray(3)
>From *libl/MyTable

Where Key1 = :MyKey;



... or even

Fetch from MyCursor
into :MyArray(1), :MyArray(2), :MyArray(3);



Apparently SQL syntax does not know about using "(1)", "(2)", and "(3)"
to designate the target array elements. Is there a way to code that to
be acceptable to SQL and to the V5R4 pre-compiler?



I'm hoping not to have to dump the results into a data structure,
because I ultimately need to reference the results by an index, and it
would be great to get them to load directly into the array if possible.



If only I knew the trick...



Thanks
Michael Koester

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.