RE: SQL select into [array]?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> 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