×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 16 Nov 2012 11:59, Lim Hock-Chai wrote:
The stored procedure does not exist yet. I don't think RPG SQL
compiler exams code against actual stored-procedure in system.
"DeLong, Eric" wrote:
How did you define the lrRequestLoginResetSP stored procedure?
Perhaps the piUserID parameter is defined as IN/OUT, when it
should only be IN...
FWiW:
_i Defining an external procedure i_
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/sqlp/rbafydfnid.htm
"...
It is important to note that it is not necessary to define a procedure
in order to call it. However, if no procedure definition is found,
either from a prior CREATE PROCEDURE or from a DECLARE PROCEDURE in this
program, certain restrictions and assumptions are made when the
procedure is called on the CALL statement. For example, the NULL
indicator argument cannot be passed."
_Using the embedded CALL statement where no procedure definition exists_
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/sqlp/rbafystatwo.htm
"A static CALL statement without a corresponding CREATE PROCEDURE
statement is processed with these rules.
* All host variable arguments are treated as INOUT type parameters.
* The CALL type is GENERAL (no indicator argument is passed).
* The program to call is determined based on the procedure name
specified on the CALL, and, if necessary, the naming convention.
* The language of the program to call is determined based on
information retrieved from the system about the program.
..."
_i Using the dynamic CALL statement where no CREATE PROCEDURE exists i_
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/sqlp/rbafydynamiccall.htm
"These rules pertain to the processing of a dynamic CALL statement when
there is no CREATE PROCEDURE definition.
* All arguments are treated as IN type parameters.
* The CALL type is GENERAL (no indicator argument is passed).
* The program to call is determined based on the procedure name
specified on the CALL and the naming convention.
* The language of the program to call is determined based on
information retrieved from the system about the program.
..."
kwds: not registered not declared
midrange.com
