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.
GET_ROUTINE_SAR procedure
The GET_ROUTINE_SAR procedure retrieves the necessary information to install the same routine in another database server running the same level on the same operating system.
PUT_ROUTINE_SAR procedure
The PUT_ROUTINE_SAR procedure passes the necessary file to create an SQL routine at the server and then defines the routine.
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.