| SQL Statement |
Purpose |
| ALLOCATE CURSOR |
Allocates a cursor for the result set identified by the result set locator variable. |
| ASSOCIATE LOCATORS |
Gets the result set locator value for each result set returned by a procedure. |
| CLOSE |
Closes a cursor. |
| DECLARE CURSOR |
Defines an SQL cursor. |
| FETCH |
Assigns values of a row to host variables. |
| FLUSH BUFFERPOOLS |
Writes out the dirty pages in the buffer pools to disk. |
| FLUSH EVENT MONITOR |
Writes out the active internal buffer of an event monitor. |
| FLUSH FEDERATED CACHE |
The FLUSH FEDERATED CACHE statement flushes the federated cache, allowing fresh metadata to be obtained the next time
an SQL statement is issued against the remote table or view using a federated three part name. |
| FLUSH OPTIMIZATION PROFILE CACHE |
Removes the cached optimization profiles. |
| FLUSH PACKAGE CACHE |
Removes all cached dynamic SQL statements currently in the package cache. |
| FREE LOCATOR |
Removes the association between a locator variable and its value. |
| LOCK TABLE |
Either prevents concurrent processes from changing a table or prevents concurrent processes from using a table. |
| OPEN |
Prepares a cursor that will be used to retrieve values when the FETCH statement is issued. |
| SELECT INTO |
Specifies a result table of no more than one row and assigns the values to host variables. |
| SET variable |
Assigns values to variables. |
| VALUES INTO |
Specifies a result table of no more than one row and assigns the values to host variables. |
