Re: SQL Statement Not Allowed

[Charles Wilt <charles.wilt@xxxxxxxxx>]

If that's a copy paste, then you have two SELECTs
Select Select FLDA, FLDB +

HTH,
Charles

On Mon, Nov 29, 2010 at 3:06 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
> I'm trying to do this to return a result set that I can process from a PHP
> script:
>
>         MySQLStmt =
>            'Declare C1 Cursor With Return For +
>              Select Select FLDA, FLDB +
>                From INVENTORY +
>                Where PARTNUM =' +
>                cBlank +
>                pInModel +
>                cBlank +
>              'For Read Only';
>
> I then prepare the statement, and I get an SQL0084 - SQL statement not
> allowed.
>
> Is it because I'm on V5R4?
>
> 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.