Database User-Defined Data Types (UDTs)

Use this page to view information about user-defined data types (UDTs) in a database.

The page displays the following information about the UDTs in the database:

• Type Name
• Owner
• Mode:
  • Distinct: Have the same internal structure as existing data types. They have distinct names and functions that make them different from the source type.
  • Opaque: Have an internal structure that is not known to the database server.
  • Collection or unnamed ROW: Include groups of elements of the same data type, which can be any built-in or complex data type.
  • Named ROW: Include groups of related data fields of any data type that form a template for a record.
• Description
• Length: The length in bytes for fixed-length data types. Zero indicates a variable-length UDT.
• Max Length: The maximum length for variable-length data types. Zero indicates a fixed-length UDT.
• By Value: Indicates whether the UDT is passed by value or by reference.
• Cannot Hash: Indicates whether the UDT can use the default hash function. A check mark in the column indicates that the UDT cannot use the default hash function. If an opaque type UDT cannot use the default hash function, the UDT must be created with the cannot hash modifier. For information about the cannot hash modifier, see the IBM® developerWorks® article Can Your Opaque Type Use Built-In Hashing?
• Align: The alignment for the UDT.