Re: host variable not permitted here

[Steve Richter <stephenrichter@xxxxxxxxx>]

thanks.

I coded around it by using two sql statements.  Create table.   Then insert
into table ( select fields from table where column = :value ).

-Steve




On Thu, Nov 10, 2011 at 10:22 AM, Mark Walter <mwalter@xxxxxxxxxxxxxxx>wrote:

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