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
Large-Object Data Types

Large-Object Data Types

Large-object data types can store extremely large column values, such as images and documents, independently of the column.

Large-Object Data Type

Notes:

¹ Optical Subsystem only


Element	Description	Restrictions	Syntax
blobspace	Name of an existing blobspace	Must exist	Identifier
family_name	Family name or variable in the optical family	Must exist	Quoted String.

The large object data types can be classified in two categories:

Simple large objects: TEXT and BYTE
Smart large objects: CLOB and BLOB

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.