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.

The superstores_demo database

The superstores_demo database illustrates an object-relational schema.

SQL files and user-defined routines (UDRs) that are provided with DB-Access let you derive the superstores_demo object-relational database.

The superstores_demo database uses the default locale and is not ANSI-compliant.

For information about how to create and populate the demonstration databases, including relevant SQL files, see the HCL OneDB™ DB-Access User's Guide. For conceptual information about demonstration databases, see the HCL OneDB Database Design and Implementation Guide.