Setting Distinct-Type Fields

The following item-descriptor fields provide information about a column that has a distinct type as its data type:
  • The SOURCEID field stores the extended identifier for the source data type.

    Set this field if the source type of the distinct type is an opaque data type. This integer value must correspond to a value in the source column for the row of the sysxtdtypes system catalog table whose extended_id value matches that of the distinct type you are setting.

  • TheSOURCETYPE field stores the data type constant for the source data type.

    This value is the data type constant for the built-in data type that is the source type for the distinct type. The codes for the SOURCETYPE field are the same as those for the TYPE field (page Setting the TYPE or ITYPE Field). This integer value must correspond to the value in the type column for the row of the sysxtdtypes system catalog table whose extended_id value matches that of the distinct type you are setting.

For more information on the sysxtdtypes system catalog table, see the HCL OneDB™ Guide to SQL: Reference.