SQLPROCEDURES

The SQLPROCEDURES view contains one row for every procedure. The following table describes the columns in the view:

Table 146. SQLPROCEDURES view
Column Name Data Type Description
PROCEDURE_CAT VARCHAR(128) Relational database name
PROCEDURE_SCHEM VARCHAR(128) Name of the schema of the procedure instance.
PROCEDURE_NAME VARCHAR(128) Name of the procedure.
NUM_INPUT_PARAMS SMALLINT Identifies the number of input parameters. 0 indicates that there are no input parameters.
NUM_OUTPUT_PARAMS SMALLINT Identifies the number of output parameters. 0 indicates that there are no output parameters.
NUM_RESULT_SETS SMALLINT Identifies the maximum number of result sets returned. 0 indicates that there are no result sets.
REMARKS VARCHAR(2000)
Nullable
A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

PROCEDURE_TYPE SMALLINT Reserved. Contains 0.
NUM_INOUT_PARAMS SMALLINT Identifies the number of input/output parameters. 0 indicates that there are no input/output parameters.