Re: host variable not permitted here

Create a statement variable and use "EXECUTE IMMEDIATE :mySqlStatement"

Mark Walter
Business to Business Data Integration Specialist
Certified IBM System i Specialist
Paragon Consulting Services, Inc.
mwalter@xxxxxxxxxxxxxxx
717-764-7909 ext. 126
________________________________________
From: rpg400-l-bounces@xxxxxxxxxxxx [rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Steve Richter [stephenrichter@xxxxxxxxx]
Sent: Thursday, November 10, 2011 9:41 AM
To: RPG programming on the IBM i / System i
Subject: host variable not permitted here

is there a way around this limitation by RPG: ( I am on V5R4 )

c/exec sql
c+ create table qtemp/ShipOrdCx as (
c+ select a.libname, a.custnbr, a.ponbr,
c+ decimal(count(*),3,0) PoOrdCount
c+ from shiphdrp a
c+ where a.runid = :vRunId
c+ group by a.libname, a.custnbr, a.ponbr
c+ ) with data
c/end-exec

I get an error: Host variable not permitted here.

Using STRSQL, the create table as statement runs without error.

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