Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe 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.
Overview of SQL syntax These topics provide an overview about how to use the SQL statements, SPL statements, and syntax segments.
Categories of SQL Statements
Data Manipulation Language Statements

Data Manipulation Language Statements

DELETE
INSERT
LOAD
MERGE
SELECT
UNLOAD
UPDATE

Note: DELETE, INSERT, MERGE, SELECT, and UPDATE are DML statements in the ANSI/ISO standard for SQL, where MERGE can emulate INSERT and DELETE or UPDATE. Although LOAD and UNLOAD resemble DML in their functionality, these DB-Access macros are out-of-scope for most references in this document to "DML statements."