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

User-Defined Data Type

A user-defined data type is one that a user defines for the database server. HCL OneDB™ supports two categories of user-defined data types, namely distinct data types and opaque data types. This is the declaration syntax for user-defined data types:

Notes:

¹ See Owner name


Element	Description	Restrictions	Syntax
distinct_type	Distinct data type with same structure as an existing data type	Must be unique among data type names in the database	Identifier
opaque_type	Name of the opaque data type	Must be unique among data type names in the database	Identifier

In this document, user-defined data type is usually abbreviated as UDT.