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 1. 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
DECFLOAT
Decimal floating-point
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
NATIONAL CHARACTER
National character
NATIONAL CHARACTER VARYING
Varying-length national character
NATIONAL CHARACTER LARGE OBJECT
National character large object
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
Start of changeXMLEnd of change
Start of changeXMLEnd of change
Start of changeUSER-DEFINEDEnd of change
Distinct type or array type
CHARACTER_MAXIMUM_LENGTH INTEGER

Nullable

Start of changeMaximum 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.

End of change
CHARACTER_OCTET_LENGTH INTEGER

Nullable

Start of changeNumber of bytes for binary, character, and graphic string and XML data types.

Contains the null value if the parameter is not a string.

End of change
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:
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.
Start of changeUDT_CATALOGEnd of change Start of changeVARCHAR(128)

Nullable

End of change
Start of changeThe 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.

End of change
Start of changeUDT_SCHEMAEnd of change Start of changeVARCHAR(128)

Nullable

End of change
Start of changeThe 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.

End of change
Start of changeUDT_NAMEEnd of change Start of changeVARCHAR(128)

Nullable

End of change
Start of changeThe name of the distinct type or array type.

Contains the null value if this is not a distinct type or array type.

End of change
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.
Start of changeMAXIMUM_CARDINALITYEnd of change Start of changeBIGINT

Nullable

End of change
Start of changeThe 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.

End of change
DTD_IDENTIFIER VARCHAR(128)

Nullable

A unique internal identifier for the parameter.