DB2 Universal Database for iSeries SQL Reference

USER_DEFINED_TYPES

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

Table 162. 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 INTEGER
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.


Footnotes:

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]