Jump to main content
Product Documentation
Customer Support
HCL OneDB 2.0.1
What's new in
HCL OneDB™
2.0.1
Getting Started
Installing
Administering
Migrating and upgrading
Data warehousing
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Troubleshooting
HCL OneDB™
OneDB PDF guides
Search
HCL OneDB Documentation Homepage
Version 2.0.1
Version 2.0.0.0
Version 1.0.1
Version 1.0.0.1
Version 1.0.0.0
HCL OneDB Containerized Deployment Guide
English
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.
Rate this topic
5 stars
4 stars
3 stars
2 stars
1 star
Comment on this topic
By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at
https://hcltechsw.com/resources/us-government-contact
. Do not include any personal data in this Comment box.