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 Opaque-Type Fields

Setting Opaque-Type Fields

The following item-descriptor fields provide information about a column that has an opaque type as its data type:

The EXTYPEID field stores the extended identifier for the opaque type. This integer value must correspond to a value in the extended_id column of the sysxtdtypes system catalog table.
TheEXTYPENAME field stores the name of the opaque type. This character value must correspond to a 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 value is the length, in bytes, of the string in the EXTYPENAME field.
The EXTYPEOWNERNAME field stores the name of the opaque-type owner. This character value must correspond to a 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 value is the length, in bytes, of the string in the EXTYPEOWNERNAME field.

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