Re: SQL Statement Not Allowed

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!