RE: SQL Statement Not Allowed

From the V5R4 SQL reference manual page 743:

WITH RETURN

Specifies that the result table of the cursor is intended to be used as a result set that will be returned from a procedure. WITH RETURN is relevant only if the DECLARE CURSOR statement is contained within the source code for a procedure. In other cases, the precompiler may accept the clause, but it has no effect.

Although that might not be the cause of the error. Instead of embedding the SQL in an RPG program shouldn't you code the SQL in a procedure?

Paul Morgan

Principal Programmer Analyst
IS Supply Chain/Replenishment

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Monday, November 29, 2010 3:06 PM
To: RPG programming on the IBM i / System i
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!