Describing an Opaque-Type Column (IDS)

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.

Use these field names with the GET DESCRIPTOR statement to obtain information about an opaque column.