DB2 Version 4.1: Creating a stored procedure

Creating a stored procedure

Precompile, compile, and link edit the program. (Use RENT option on the link edit, otherwise executions of the stored procedure are serialized).

Bind a package for the program.

Record the stored procedure in the DB2 catalog by inserting a row for the stored procedure into SYSIBM.SYSPROCEDURES. It is here that the parameter list and other pertinent data about the stored procedure is recorded.

Grant execution authority on the stored procedure's package as appropriate.