Re: CREATE TABLE AS ... WITH DATA

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

the reference manual has lots of info on where host variables are 
allowed - check the create table section - carefully look at the syntax 
and all

there are good reasons for some of these things, and they usually make 
sense after thinking about it a while

come back with quotes from that section, then we can respond better

regards
vern

Michael_Schutte@xxxxxxxxxxxx wrote:
> It's not a compile message.  It's interactive SQL checking that it was
> barfing on.    The message was  "HOST VARIABLE NOT PERMITTED HERE".
>
> I thought it might be a mistake so I saved it anyway and tried to compile,
> and the compile message was the same.  It's not allowing host variables
> when trying to create table with data. I just understand why.
>
>
> --
>
> Michael Schutte
> Admin Professional
>
>
>
> BIG FARM SALADS: Made when you're ready, not ready made.
> Try our NEW Savor-Size Country Caesar Salad for 5.99!
> For more information, visit BobEvans.com
>
>
>
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 05/07/2009 08:44:35 AM:
>
>   
> > Michael wrote:
> >   Okay... but why?  That's what I'm trying to figure.  Instead of doing a
> >   prepare statement, I've just broken it up.  Create table first, then
> > insert
> >   table.
> >
> >
> > Michael -
> > What were the messages on the compile listing?
> > - sjl
> >
> >
> >
> >
> > --
> > 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.
> >
> >