Describing an Opaque-Type Column

The DESCRIBE statement sets the following item-descriptor fields when the column to fetch has an opaque type as its data type:

• The EXTYPEID field stores the extended ID for the opaque type. This integer is the value in the corresponding extended_id column of the sysxtdtypes system catalog table.
• The EXTYPENAME field stores the name of the opaque type. This character value is the value in the name column of the row with the matching extended_id value in the sysxtdtypes system catalog table.
• The EXTYPELENGTH field stores the length of the opaque-type name. This integer is the length of the data type name (in bytes).
• The EXTYPEOWNERNAME field stores the name of the opaque-type owner. This character value is the value in the owner column of the row with the matching extended_id value in the sysxtdtypes system catalog table.
• The EXTYPEOWNERLENGTH field stores the length of the value in the EXTTYPEOWNERNAME field. This integer is the length, in bytes, of the name of the owner of the opaque type.