Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET DESCRIPTOR statementUse the SET DESCRIPTOR statement to set values in a system-descriptor area (SDA).
Item Descriptor
Setting Distinct-Type Fields

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.