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
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 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.
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.
Contains the null value if this is not a distinct type. |
UDT_SCHEMA | VARCHAR(128)
Nullable | The name of the schema if this is a distinct type.
Contains the null value if this is not a distinct type. |
UDT_NAME | VARCHAR(128)
Nullable | The name of the distinct type.
Contains the null value if this is not a distinct 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 | INTEGER
Nullable | Reserved. Contains the null value. |
DTD_IDENTIFIER | VARCHAR(128)
Nullable | A unique internal identifier for the parameter. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.