Jump to main content
Product Documentation
Customer Support
HCL OneDB V 1.0.1.0
What's new in
HCL OneDB™
1.0.1.0
Getting Started
Installing
Administering
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Search
Home
SQL programming
You can use the
HCL OneDB™
implementation of the SQL language to develop applications for
HCL OneDB™
database servers.
Guide to SQL: Reference
The
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
SQL programming
You can use the
HCL OneDB™
implementation of the SQL language to develop applications for
HCL OneDB™
database servers.
Guide to SQL: Syntax
The
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.
Guide to SQL: Reference
The
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™
.
System catalog tables
The
system catalog
consists of tables and views that describe the structure of the database. Sometimes called the
data dictionary
, these table objects contain everything that the database knows about itself. Each system catalog table contains information about specific elements in the database. Each database has its own system catalog.
Data types
Every 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.
Environment variables
Various
environment variables
affect the functionality of your
HCL OneDB™
products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Appendixes
The stores_demo Database
The
stores_demo
database contains a set of tables that describe an imaginary business and many of the examples in the
HCL OneDB™
documentation are based on this database.
The superstores_demo database
The
superstores_demo
database illustrates an object-relational schema.
Guide to SQL: Tutorial
The
HCL OneDB™
Guide to SQL: Tutorial
shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases.
It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Appendixes
The stores_demo Database
The
stores_demo
database contains a set of tables that describe an imaginary business and many of the examples in the
HCL OneDB™
documentation are based on this database.
The superstores_demo database
The
superstores_demo
database illustrates an object-relational schema.