The SQLPROCEDURECOLS view contains one row for every parameter of a
procedure. The following table describes the columns in the view:
Table 140. SQLPROCEDURECOLS view
Column Name | Data Type | Description |
---|---|---|
PROCEDURE_CAT | VARCHAR(128) | Relational database name |
PROCEDURE_SCHEM | VARCHAR(128) | Schema name of the procedure instance. |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure instance. |
COLUMN_NAME | VARCHAR(128)
Nullable | Name of a procedure parameter.
Contains the null value if the parameter does not have a name. |
COLUMN_TYPE | SMALLINT | Type of the parameter:
|
DATA_TYPE | SMALLINT | The data type of the parameter:
|
TYPE_NAME | VARCHAR(260) | The name of the data type of the parameter:
|
COLUMN_SIZE | INTEGER | Length of the parameter. |
BUFFER_LENGTH | INTEGER | Indicates the length of the parameter in a buffer. |
DECIMAL_DIGITS | SMALLINT
Nullable | Scale of numeric or datetime data.
Contains the null value if the parameter is not decimal, numeric, binary, time or timestamp. |
NUM_PREC_RADIX | SMALLINT
Nullable | Indicates if the precision specified in column NUMERIC_PRECISION is
specified as a number of binary or decimal digits:
Contains the null value if the parameter is not numeric. |
NULLABLE | SMALLINT | Indicates whether the parameter is nullable.
|
REMARKS | VARCHAR(2000)
Nullable | A character string supplied with the COMMENT statement.
Contains the null value if there is no long comment. |
COLUMN_DEF | VARCHAR(1)
Nullable | The default value for the column.
Contains the null value if there is no default value. |
SQL_DATA_TYPE | SMALLINT | The SQL data type of the parameter:
|
SQL_DATETIME_SUB | SMALLINT
Nullable | The datetime subtype of the parameter:
Contains the null value if the data type is not a datetime data type. |
CHAR_OCTET_LENGTH | INTEGER
Nullable | Indicates the length in characters of the parameter.
Contains the null value if the column is not a string. |
ORDINAL_POSITION | INTEGER | Numeric place of the parameter in the parameter list, ordered from left to right. |
IS_NULLABLE | VARCHAR(3) | Indicates whether the parameter is nullable.
|
JDBC_DATA_TYPE | SMALLINT | The JDBC data type of the parameter:
|
I_DATA_TYPE | SMALLINT | Indicates the iSeries CLI data type of the column.
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.