USER_DEFINED_TYPE_CATALOG |
VARCHAR(128) |
Relational database name |
USER_DEFINED_TYPE_SCHEMA |
VARCHAR(128) |
Schema name of the distinct type. |
USER_DEFINED_TYPE_NAME |
VARCHAR(128) |
Name of the user that created the distinct type. |
USER_DEFINED_TYPE_CATEGORY |
VARCHAR(128) |
Indicates the type of user-defined type.
Contains 'DISTINCT'. |
IS_INSTANTIABLE |
VARCHAR(3) |
Reserved. Contains 'YES'. |
IS_FINAL |
VARCHAR(3) |
Reserved. Contains 'YES'. |
ORDERING_FORM |
VARCHAR(4) |
Indicates what kind of predicates are allowed
when this distinct type is a comparand:
- FULL
- All predicates are allowed.
- NONE
- No predicates are allowed
|
ORDERING_CATEGORY |
VARCHAR(8) |
Reserved. Contains 'MAP'. |
ORDERING_ROUTINE_CATALOG |
VARCHAR(128)
Nullable
|
Relational database name
Contains the null
value if the ORDERING_FORM is 'NONE'. |
ORDERING_ROUTINE_SCHEMA |
VARCHAR(128)
Nullable
|
Reserved. Contains 'SYSIBM'.
Contains
the null value if the ORDERING_FORM is 'NONE'. |
ORDERING_ROUTINE_NAME |
VARCHAR(128)
Nullable
|
Reserved. Contains a data type name.
Contains
the null value if the ORDERING_FORM is 'NONE'. |
REFERENCE_TYPE |
VARCHAR(16)
Nullable
|
Reserved. Contains the null value. |
DATA_TYPE |
VARCHAR(128)
Nullable
|
Source data type of the distinct type:
- 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 distinct type for binary, character,
and graphic string data types.
Contains the null value if the distinct type is
not a string. |
CHARACTER_OCTET_LENGTH |
INTEGER
Nullable
|
Number of bytes of the distinct type for binary,
character, and graphic string data types.
Contains the null value if the distinct type is
not a string. |
CHARACTER_SET_CATALOG |
VARCHAR(128)
Nullable
|
Relational database name of the distinct type.
Contains the null value if the distinct type is not a string. |
CHARACTER_SET_SCHEMA |
VARCHAR(128)
Nullable
|
The schema name of the character set of the distinct type.
Contains 'SYSIBM'.
Contains the null value if the distinct type is not a string. |
CHARACTER_SET_NAME |
VARCHAR(128)
Nullable
|
The character set name of the distinct type.
Contains
the null value if the distinct type is not a string. |
COLLATION_CATALOG |
VARCHAR(128)
Nullable
|
Relational database name of the distinct type.
Contains the null value if the distinct type is not a string. |
COLLATION_SCHEMA |
VARCHAR(128)
Nullable
|
The schema of the collation of the distinct type.
SYSIBM is returned.
Contains the null value if the distinct type is not a string. |
COLLATION_NAME |
VARCHAR(128)
Nullable
|
The collation name of the distinct type. IBMBINARY
is returned.
Contains the null value if the distinct type is not a string. |
NUMERIC_PRECISION |
INTEGER
Nullable
|
The precision of the distinct type.
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 distinct type 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 distinct type is not numeric. |
NUMERIC_SCALE |
SMALLINT
Nullable
|
Scale of numeric distinct type.
Contains the null
value if the distinct type is not decimal, numeric, or binary. |
DATETIME_PRECISION |
INTEGER
Nullable
|
The fractional part of a date, time, or timestamp distinct type.
- 0
- For DATE and TIME data types
- 6
- For TIMESTAMP data types (number of microseconds).
Contains the null value if the distinct type is not date, time, or timestamp. |
INTERVAL_TYPE |
VARCHAR(128)
Nullable
|
Reserved. Contains the null value. |
INTERVAL_PRECISION |
INTEGER
Nullable
|
Reserved. Contains the null value. |
SOURCE_DTD_IDENTIFIER |
VARCHAR(128)
Nullable
|
A unique internal identifier for the source
data type.
Contains the null value if the distinct type is not sourced on another distinct type. |
REF_DTD_IDENTIFIER |
VARCHAR(256)
Nullable
|
Reserved. Contains the null value. |