SQL Statement | Description |
|
|
INSERT | Inserts rows of data into a table or view. |
|
|
LOCK TABLE | Locks the specified table (or underlying tables of a view) |
| and its associated indexes for the duration of the active |
| transaction. |
|
|
MAINTAIN | Performs one or more table maintenance tasks, such as |
| REORG, UPDATE STATISTICS, and REFRESH, on a |
| specified database object. |
|
|
POPULATE INDEX | Loads a specified index with data from a specified table. |
|
|
PREPARE | Compiles an SQL statement for later use with the |
| EXECUTE statement. |
|
|
PURGEDATA | Deletes all data from a table and its related indexes. |
|
|
REORG | Reorganizes data in a table or index and compacts space |
| needed for rows by removing unused space. |
|
|
REVOKE | Revokes access privileges for a table or view from specified |
| users. |
|
|
ROLLBACK WORK | Undoes all modifications to database objects during the |
| current transaction, releases all locks on database objects |
| held by the transaction, and ends the transaction. |
|
|
SELECT | Retrieves data from tables, views, derived tables |
| determined by the evaluation of query expressions, or |
| joined tables. |
|
|
SET SCHEMA | Sets the schema name for unqualified object names for the |
| current session. |
|
|
SET TABLE TIMEOUT | Sets a dynamic timeout value for a lock timeout or a stream |
| timeout in the environment of the current session. |
|
|
SET TRANSACTION | Sets attributes, such as isolation level and access mode, |
| for the next transaction. |
|
|
UPDATE | Updates data in a row or rows of a table or updateable |
| view. |
|
|
UPDATE STATISTICS | Updates histogram statistics for one or more groups of |
| columns in a table. |
|
|
134 Supported SQL Statements