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.)

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.