Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Data typesEvery column in a table in a database is assigned a data type. The data type precisely defines the kinds of values that you can store in that column.
Built-In Data Types
Large-Object Data Types

Large-Object Data Types

A large object is a data object that is logically stored in a table column but physically stored independent of the column. Large objects are stored separate from the table because they typically store a large amount of data. Separation of this data from the table can increase performance.

Large-Object Data Types shows the large-object data types.

Labelled rectangles depict the logical hierarchy of Large-object data types. The Simple large objects include BYTE and TEXT data types. The Smart large objects include BLOB and CLOB data types. End figure description — Figure 1: Large-Object Data Types

Only HCL OneDB™ supports BLOB and CLOB data types.

For the relative advantages and disadvantages of simple and smart large objects, see the HCL OneDB Database Design and Implementation Guide.