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.
Built-In Data Types

Built-In Data Types

Built-in data types are data types that are defined by the database server.

Built-In Data Type

Notes:

¹ See BOOLEAN and other built-in opaque data types
² See BSON and JSON built-in opaque data types
³ See Character Data Types
⁴ See Numeric Data Types
⁵ HCL OneDB extension
⁶ See Large-Object Data Types
⁷ See Time Data Types
⁸ See IDSSECURITYLABEL Data Type

These data types are built into the database server in the sense that the information and support functions required to interpret and transfer these data types is part of the database server software, which supports character, numeric, large-object, and time categories of built-in data types.