The SQLPROCEDURES view contains one row for every procedure.
The following table describes the columns in the 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 | INTEGER | Identifies the number of input parameters. 0 indicates that there are no input parameters. |
| NUM_OUTPUT_PARAMS | INTEGER | 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 | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
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 | INTEGER | Identifies the number of input/output parameters. 0 indicates that there are no input/output parameters. |
| SPECIFIC_NAME | VARCHAR(128) | Specific name of the procedure instance. |