Products Support Documentation Download
Database Manipulation Language (DML) Reference

Each individual SQL statement is described in this section. The descriptions are listed in alphabetical order by statement.

The following table summarizes each RDM SQL statement. The following table summarizes each RDM SQL statement. Those statements that include "(SQL PL)" in the description can only be used within a stored procedure or function.

DDL Command Description
COMMIT Commit transaction's changes to the database.
ROLLBACK Rollback (undo) a transaction's changes.
CLOSE DATABASE Close an open database.
CREATE {DATABASE | SCHEMA} Create a database or schema definition.
OPEN DATABASE Open a database.
DELETE Delete one or more rows from a table.
DROP DATABASE Drop a database.
INSERT Insert a row or rows into a table.
START TRANSACTION Start a transaction.
UPDATE Update one or more rows in a table.