Parameters Passed to
RLX
Stored Procedures

Review 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 parameter
    CHAR(18) NULLS
    specifies the name of the
    RLX
    exec to be invoked.
  • The second parameter
    VARCHAR(2048) NULLS
    provides the input argument to be passed to the REXX exec.
  • The third parameter
    VARCHAR(2048) NULLS
    specifies 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)