DB2 10.5 for Linux, UNIX, and Windows

SQL procedure routines

This grouping of routines and views can be used to interact with SQL routines and packages.

ALTER_ROUTINE_PACKAGE procedure
This procedure alters values for the package associated with a compiled SQL routine or a compiled trigger, without the need for rebinding.
GET_ROUTINE_NAME procedure - get SQL PL object name
The GET_ROUTINE_NAME procedure returns the name of an SQL PL object given the object's LIB_ID.
GET_ROUTINE_OPTS scalar function
The GET_ROUTINE_OPTS function returns a character string value of the options that are to be used for the creation of SQL procedures in the current session.
REBIND_ROUTINE_PACKAGE procedure - rebind a package
The REBIND_ROUTINE_PACKAGE procedure rebinds the package associated with an SQL procedure, routine, compiled function, or trigger.
SET_ROUTINE_OPTS procedure
The SET_ROUTINE_OPTS procedure sets the options that are to be used for the creation of SQL procedures in the current session.