DB2 Server for VSE & VM: Application Programming

Using Stored Procedures

The following example shows how to define the parameters in a stored procedure that uses the GENERAL linkage convention. The NOEXECOPS procedure option must be specified.

Figure 131. Stored Procedure - Using GENERAL Linkage Convention

          PLISAMP: PROC(PARM1, PARM2, ...)
                   OPTIONS(MAIN, NOEXECOPS);
 
                   DCL PARM1 ...        /* first parameter */
                   DCL PARM2 ...        /* second parameter */
            .
            .
            .

The following example shows how to define the parameters in a stored procedure that uses the GENERAL WITH NULLS linkage convention.

Figure 132. Stored Procedure - Using GENERAL WITH NULLS Linkage Convention

          PLISAMP: PROC(PARM1, PARM2, INDSTRUC)
                   OPTIONS(MAIN, NOEXECOPS);
 
                   DCL PARM1 ...        /* first parameter */
                   DCL PARM2 ...        /* second parameter */
 
                   DCL 01 INDSTRUC,
                          02 IND1 BIN FIXED(15),  /* first ind var */
                          02 IND2 BIN FIXED(15);  /* second ind var */
...