RE: host variable not permitted here

[Mark Walter <mwalter@xxxxxxxxxxxxxxx>]

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.