The PARAMETERS view contains one row for each parameter of a routine in the relational database.
The following table describes the columns in the view:
| Column Name | Data Type | Description |
|---|---|---|
| SPECIFIC_CATALOG | VARCHAR(128) | Relational database name |
| SPECIFIC_SCHEMA | VARCHAR(128) | Schema name of the routine instance |
| SPECIFIC_NAME | VARCHAR(128) | Specific name of the routine instance |
| ORDINAL_POSITION | INTEGER | Numeric place of the parameter in the parameter list, ordered from left to right. |
| PARAMETER_MODE | VARCHAR(5) | The type of the parameter:
|
| IS_RESULT | VARCHAR(3) | Reserved. Contains 'NO'. |
| AS_LOCATOR | VARCHAR(3) | Indicates whether the parameter was
specified as a locator.
|
| PARAMETER_NAME | VARCHAR(128) Nullable |
The name of the parameter Contains the null value if the parameter does not have a name. |
| FROM_SQL_SPECIFIC_CATALOG | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| FROM_SQL_SPECIFIC_SCHEMA | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| FROM_SQL_SPECIFIC_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TO_SQL_SPECIFIC_CATALOG | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TO_SQL_SPECIFIC_SCHEMA | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TO_SQL_SPECIFIC_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| DATA_TYPE | VARCHAR(128) Nullable |
Type of the parameter:
|
| CHARACTER_MAXIMUM_LENGTH | INTEGER Nullable |
Maximum length of the
string for binary, character, and graphic string and XML data types.
Contains the null value if the parameter is not a string. ![]() |
| CHARACTER_OCTET_LENGTH | INTEGER Nullable |
Number of bytes for binary,
character, and graphic string and XML data types. Contains the null value if the parameter is not a string. ![]() |
| CHARACTER_SET_CATALOG | VARCHAR(128) Nullable |
Relational database name Contains the null value if the column is not a string. |
| CHARACTER_SET_SCHEMA | VARCHAR(128) Nullable |
The schema name of the character
set. Contains 'SYSIBM'. Contains the null value if the column is not a string. |
| CHARACTER_SET_NAME | VARCHAR(128) Nullable |
The character set name. Contains the null value if the column is not a string. |
| COLLATION_CATALOG | VARCHAR(128) Nullable |
Relational database name Contains the null value if the column is not a string. |
| COLLATION_SCHEMA | VARCHAR(128) Nullable |
The schema of the collation. SYSIBM
is returned. Contains the null value if the column is not a string. |
| COLLATION_NAME | VARCHAR(128) Nullable |
The collation name. IBMBINARY is
returned. Contains the null value if the column is not a string. |
| NUMERIC_PRECISION | INTEGER Nullable |
The precision of all numeric parameters.
Note: This column supplies the precision of all numeric data types,
including single-and double-precision floating point and decimal floating-point.
The NUMERIC_PRECISION_RADIX column indicates if the value in this
column is in binary or decimal digits.
Contains the null value if the parameter is not numeric. |
| NUMERIC_PRECISION_RADIX | INTEGER 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. |
| NUMERIC_SCALE | INTEGER Nullable |
Scale of numeric data. Contains the null value if not decimal, numeric, or binary parameter. |
| DATETIME_PRECISION | INTEGER Nullable |
The fractional part of a date, time,
or timestamp.
Contains the null value if the parameter is not a date, time, or timestamp. |
| INTERVAL_TYPE | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| INTERVAL_PRECISION | INTEGER Nullable |
Reserved. Contains the null value. |
UDT_CATALOG![]() |
VARCHAR(128) Nullable ![]() |
The relational database name if this
is a distinct type or array type.. Contains the null value if this is not a distinct type or array type. ![]() |
UDT_SCHEMA![]() |
VARCHAR(128) Nullable ![]() |
The name of the schema if this is
a distinct type or array type. Contains the null value if this is not a distinct type or array type. ![]() |
UDT_NAME![]() |
VARCHAR(128) Nullable ![]() |
The name of the distinct type or
array type. Contains the null value if this is not a distinct type or array type. ![]() |
| SCOPE_CATALOG | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| SCOPE_SCHEMA | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| SCOPE_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
MAXIMUM_CARDINALITY![]() |
BIGINT Nullable ![]() |
The maximum cardinality of the array
type if this parameter is an array type. Contains the null value if this parameter is not an array type. ![]() |
| DTD_IDENTIFIER | VARCHAR(128) Nullable |
A unique internal identifier for the parameter. |