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."