Re: CREATE TABLE AS ... WITH DATA -- RPG400-L

Host variables are used in 'Prepared' statements. The reason for that is as
the name suggests, they are prepared. ie they are created before they are
run, and when run, the host variables are passed to the already prepared
statement as input values.
This is basically for performance reasons, as the prepared statement can
then be reused multiple times efficiently

2009/5/7 <Michael_Schutte@xxxxxxxxxxxx>

Okay, I've found where is says that it's not allowed.

The select-statement must not refer to variables or include parameter
markers.

But why, I dont see the explaination why? I'm not seeing why the compiler
would care if I use a hard coded value or a host variable to select
records.

--

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

Vern Hamberg
<vhamberg@comcast
.net> To
Sent by: RPG programming on the IBM i /
rpg400-l-bounces@ System i <rpg400-l@xxxxxxxxxxxx>
midrange.com cc

Subject
05/07/2009 09:05 Re: CREATE TABLE AS ... WITH DATA
AM

Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>

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.

--
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.

--
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.