USER_DEFINED_TYPES

The USER_DEFINED_TYPES view contains one row for each distinct type.

The following table describes the columns in the view1:

Table 1. 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
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
USER-DEFINED
Distinct Type
CHARACTER_MAXIMUM_LENGTH INTEGER

Nullable

Start of changeMaximum length of the distinct type for binary, character, and graphic string and XML data types.

Contains the null value if the distinct type is not a string.

End of change
CHARACTER_OCTET_LENGTH INTEGER

Nullable

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

Contains the null value if the distinct type is not a string.

End of change
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 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 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.
1 This view does not contain information about built-in data types.