Re: SQL Statement Not Allowed

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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!