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.
Extended Data Types
Complex data typesA complex data type can store one or more values of other built-in or extended data types.
ROW Data Types

ROW Data Types

A ROW data type is an ordered collection of one or more elements, called fields. Each field has a name and a data type. The fields of a ROW are comparable to the columns of a table, but with important differences:

A field has no default clause.
You cannot define constraints on a field.
You can only use fields with row types, not with tables.

Two kinds of ROW data types exist:

Named ROW data types are identified by their names.
Unnamed ROW data types are identified by their structure.

The structure of an unnamed ROW data type is the number (and the order of data types) of its fields.

No more than 195 columns of the same table can be declared as ROW data types. For more information about ROW data types, see ROW data type, Named and ROW data type, Unnamed.

You can cast between named and unnamed ROW data types; this is described in the HCL OneDB™ Database Design and Implementation Guide.