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. |