PARAMETERS

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:

Table 158. PARAMETERS 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:
IN
This is an input parameter.
OUT
This is an output parameter.
INOUT
This is an input/output parameter.
IS_RESULT VARCHAR(3) Reserved. Contains 'NO'.
AS_LOCATOR VARCHAR(3) Indicates whether the parameter was specified as a locator.
NO
The parameter was not specified as a locator.
YES
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:
BIGINT
Big number
INTEGER
Large number
SMALLINT
Small number
DECIMAL
Packed decimal
NUMERIC
Zoned decimal
DOUBLE PRECISION
Floating point; DOUBLE PRECISION
REAL
Floating point; REAL
CHARACTER
Fixed-length character string
CHARACTER VARYING
Varying-length character string
CHARACTER LARGE OBJECT
Character large object string
GRAPHIC
Fixed-length graphic string
GRAPHIC VARYING
Varying-length graphic string
DOUBLE-BYTE CHARACTER LARGE OBJECT
Double-byte character large object string
BINARY
Fixed-length binary string
BINARY VARYING
Varying-length binary string
BINARY LARGE OBJECT
Binary large object string
DATE
Date
TIME
Time
TIMESTAMP
Timestamp
DATALINK
Datalink
ROWID
Row ID
USER-DEFINED
Distinct Type
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.

Note:
This column supplies the precision of all numeric data types, including single-and double-precision 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:
2
Binary; floating-point precision is specified in binary digits.
10
Decimal; all other numeric types are specified in 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.
0
For DATE and TIME data types
6
For TIMESTAMP data types (number of microseconds).

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.