Re: SQL0518 - What does RPG not like that the run time produces this error?

["Lennon_s_j@xxxxxxxxxxx" <lennon_s_j@xxxxxxxxxxx>]

Don't you need an "into" somewhere, so that your selected data ends up 
in a variable in the program?

Sam

On 6/21/2010 7:54 PM, Darryl Freinkel wrote:
> I have a relatively simple SQL statement that works fine in interactive SQL
> and iNavigator.
>
>
>
> However, in a RPG program (free form) that is using a prepare and EXECUTE,
> the EXECUTE fails with error -518.
>
>
>
> This error is used for a number of errors by IBM and I cannot find a
> specific error code indicating the problem.
>
>
>
> Select RRN(A1) from OEDTL01P A1 right outer join AA0000219 B1 on A1.ODORD =
> B1.LORD and A1.ODLINE = B1.LLINE where RRN(B1) = 55243
>
>
>
> Here is the code:
>
>
>
> Exec Sql Declare SQLRRN scroll cursor for SQLRRN;
>
> Exec Sql Prepare SQLRRN from :SqlRRNPrep;
>
>
>
>   If SqlCod<  0;
>
>      ErrorStatus = '1003';
>
>      p1SqlCmd = sqlRRNPrep;
>
>      logACTerr ('1003' : SqlCod : p1SqlCmd );
>
>      ReturnCode = *off ;// Failed
>
>      Return ReturnCode;
>
>   Else;
>
>     Exec Sql Execute SQLRRN ;
>
>       If SqlCod<  0;
>
>          ErrorStatus = '1004';
>
>      ENDIF;