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™.
Appendixes
The superstores_demo databaseThe superstores_demo database illustrates an object-relational schema.
Table Hierarchies

Table Hierarchies

The following illustration shows how the hierarchical tables of the superstores_demo database are related. The foreign key and primary relationships between the two tables are indicated by shaded arrows that point from the customer.custnum and customer.loc columns to the location.location_id columns.

Labelled rectangles depict 6 tables and their column names. Here retail_customer and whlsale_customer are subtables of customer, and location_us and location_non_us are subtables of location. End figure description — Figure 1: Hierarchies of superstores_demo Tables