Re: upgrade from V5R4 to V7R1

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

I would say yes. If your stored procedure definition says "NO SQL", that 
means there is NO SQL in the program. So if you DO have some SQL in your 
RPGLE, you have lied. =-O   Therefore, you will get the error.

On 10/14/2011 2:23 PM, Hockchai Lim wrote:
> We are in the process of upgrading our OS from V5R4 to V7R1.  In the V7R1
> upgrade Memo to Users 7_1.pdf, I see this little note :
>
> NO SQL clause user-defined function changes
> In prior releases, no SQL error code was issued when a user-defined function
> created with the NO SQL
> clause attempted to run an SQL statement. In i 7.1, user-defined functions
> that are created with the NO
> SQL clause specified, now issue SQLCODE -487 (SQL statements not allowed)
> when called and an
> attempt is made to run an SQL statement from inside the function.
>
>
> Does anyone know if above applies to SQL procedure that is created with
> language of RPGLE (See below)?  Meaning would it issue SQLCODE -487 if the
> RPGLE program execute a SQL statement?
>
> create procedure
>    someProc( )
>
>    language RPGLE
>
>    external name 'SOMELIB/SOMEPROC)'
>
>    program type sub
>
>    not deterministic
>
>    no sql
>
>    parameter style general;