Re: MIDRANGE-L Digest, Vol 4, Issue 2113

>
> message: 2
> date: Thu, 27 Oct 2005 13:40:38 -0400
> from: "David C. Shea" < dshea@xxxxxxxxxxxx>
> subject: SQL CREATE TABLE AS...
>
> In Oracle, I can create a new table by referencing fields in another
> table. For example:
>
> create table bakerc/drivetest as select rpdoc, rpdct, rpkco from
> pristdta/f03b11 where 1=2
>
> will create table DRIVETEST in lib BAKERC with just those three fields.
>
> I would like to be able to do this on the AS400, but this syntax doesn't
> work.
>
> It appears that you can't do this on an AS400... I'm hoping someone can
> prove me wrong??
>
>
I'm not aware of any way to do this directly. If it helps, though:

<WARNING: blatant plug>
"iHOC Query" (http://www.ihocquery.com) is scheduled to launch on Nov 1st,
and one of its many capabilities is to create "Dump Files" from SQL select
statement results. You could easily use this to create the appropriate
"Create Table" statement, and then (still using iHOC) issue the statement to
create the table. For more info on iHOC, either visit the address above or
e-mail me offline.
<end blatant plug>

--
Joel Cochran