USER_DEFINED_TYPES

The USER_DEFINED_TYPES view contains one row for each distinct type.115 The following table describes the columns in the view:

Table 167. USER_DEFINED_TYPES view
Column Name Data Type Description
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.

115.
This view does not contain information about built-in data types.