Re: SQL Statement Not Allowed

[dmosley@xxxxxxxxxx]

I don't think you want to dynamically DECLARE your cursor.  It doesn't 
really make sense to do that.  Make the DECLARE  static, then simply OPEN 
the cursor.

Declare C1 Cursor With Return For 
              Select Select FLDA, FLDB 
                From INVENTORY 
                Where PARTNUM = :pInModel    <<--- Note the change to the 
Where clause.
              For Read Only;

Open C1;


David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com 



Michael Ryan <michaelrtr@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/29/2010 03:06 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
SQL Statement Not Allowed






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!