Parameters Passed to RLX Stored Procedures
RLX
Stored ProceduresReview the list of standard parameters that must be passed to all Db2 stored procedures implemented as
RLX
execs.A standard parameter list must be passed to all Db2 stored procedures implemented as
RLX
execs. The RLX
stored procedure dispatcher (load module RLX
YSPD) assumes three parameters are passed to it, followed by a null indicator structure containing an indicator variable for each parameter. The null indicator structure is not defined in the parmlist. The following three parameters are defined:- The first parameterCHAR(18) NULLSspecifies the name of theRLXexec to be invoked.
- The second parameterVARCHAR(2048) NULLSprovides the input argument to be passed to the REXX exec.
- The third parameterVARCHAR(2048) NULLSspecifies the result returned by the stored procedure.
For Db2 releases before Version 6, the PARMLIST column of the SYSPROCEDURES table should be specified as follows:
EXEC CHAR(18) IN, INPUT VARCHAR(2048) IN, OUTPUT VARCHAR(2048) OUT
For Db2 Version 6 and subsequent releases, the Parameter Declaration of the SQL CREATE PROCEDURE statement should specify:
IN EXEC CHAR(18), IN INPUT VARCHAR(2048), OUT OUTPUT VARCHAR(2048)