User-Defined Data Type
A user-defined data type is one that a user defines for
the database server. Informix® supports
two categories of user-defined data types, namely distinct data
types and opaque data types. This is the declaration syntax
for user-defined data types:
User-Defined Data Type |--+-----------------------+--+-opaque_type---+-----------------| | (1) | '-distinct_type-' '-| Owner Name |------.-'
Notes:
- See Owner name
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| distinct_type | Distinct data type with same structure as an existing data type | Must be unique among data type names in the database | Identifier |
| opaque_type | Name of the opaque data type | Must be unique among data type names in the database | Identifier |
In this document, user-defined data type is usually abbreviated as UDT.