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 | 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. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.