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.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Data TypeThe Data Type segment specifies the data type of a column, of a component of a collection, of a field within a ROW type, of a routine parameter, or of a value returned by an expression or by a cast function. Use this segment whenever you see a reference to a data type in a syntax diagram.
User-Defined Data Type
Distinct Data Types

Distinct Data Types

A DISTINCT data type is a user-defined data type that is based on one of the following data types:

a built-in type (including built-in opaque types)
a user-defined opaque type
a named ROW type
an existing DISTINCT type.

The base type of a DISTINCT type cannot be any of the following data types:

an unnamed ROW type
a LIST, MULTISET, SET, or generic COLLECTION type.

The DISTINCT type inherits the length and the alignment of its base type in storage. HCL OneDB™ automatically creates explicit casts between the DISTINCT type and its base type. To create a DISTINCT type, you must use the CREATE DISTINCT TYPE statement. (For more information, see CREATE DISTINCT TYPE statement.)