HCL OneDB SQL and ANSI SQL

The HCL® OneDB® implementation of SQL is compatible with standard SQL. HCL OneDB SQL is also compatible with the IBM version of the language. However, HCL OneDB SQL contains extensions to the standard; that is, extra options or features for certain statements, and looser rules for others. Most of the differences occur in the statements that are not in everyday use. For example, few differences occur in the SELECT statement, which accounts for 90 percent of SQL use.

When a difference exists between HCL OneDB SQL and ANSI standard, the HCL OneDB Guide to SQL: Syntax identifies the HCL OneDB syntax as an extension to the ANSI standard for SQL.