Re: SQL Statement Not Allowed

Hi Michael,

You can't put the 'Declare C1 Cursor' part in a character string. The 'Declare C1 Cursor' is instructions to the embedded SQL precompiler telling it which code to generate... you can't put the contents in a character string, because the contents of a variable is something that's only used at run-time, not (pre-)compile time.

From what I can tell in your posted example, you don't really need embedded SQL at all. You can write this as an SQL Stored procedure, it's probably easier

If you _are_ going to use embedded SQL, why not use a static statement? Static statements are much easier to deal with that dynamic ones.

If there's more than meets the eye, and you really do need dynamic statements, the SELECT stuff can go in a character string, but needs to be run through a 'Prepare', then the 'Declare Cursor' would run off of the prepared statement, and the 'Declare Cursor' would be static.




On 11/29/2010 2:06 PM, Michael Ryan 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!