Re: RPG-ILE Service Pgm and Parameter Passing

Blair Smith wrote:

However, it was soon discovered that SQL calling RPGLE did NOT
provide the minimum operational descriptor information that allows
the %PARMS BIF to work (as is true for several processes that can
invoke RPGLE). The quick workaround was to check for parameters with
a valid address - if the parameter had a valid address, it must have
been passed - OR SO ONE WOULD THINK. In testing, this SEEMED to
work.

That's interesting. I'm pretty sure CEETSTA does exactly the same thing as if %ADDR(PARM)=*NULL. (Not all languages have the ability to check the address of a parameter, indeed RPG didn't have this capability at first -- and CL only got it recently. So CEETSTA is necessary.)

So I guess I'm wondering what's going on here... How the heck does CEETSTA solve the problem? It does the same thing!

You're correct that %PARMS won't work with SQL. %PARMS is part of that operational descriptor I mentined earlier -- and SQL doesn't supply a descriptor (not even a minimal one) so there's no parameter count. But that shouldn't have any impact on whether %ADDR(PARM) does or doesn't work. And since CEETSTA is supposed to be identical to %ADDR(PARM) I'm a bit confused at your message.