Re: SQL select into [array]?

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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
>