SQL statements for querying and updating data

SQL statement	Function
SELECT1	Transfers the values of a row to a host variable
UPDATE	Updates column values in rows determined by a search condition
DELETE	Deletes from a table rows determined by a search condition
INSERT	Inserts rows in a table
MERGE	Inserts new records in a table and modifies existing records
CALL	Executes a procedure
DECLARE CURSOR2	Declares a cursor
OPEN2	Opens a cursor
FETCH2	Positions on a row in the cursor table and reads this row
UPDATE...CURRENT2	Updates the current row in the cursor table
DELETE... CURRENT2	Deletes the current row in the table
CLOSE2	Closes a cursor
STORE2	Stores the current cursor position
RESTORE2	Restores a cursor stored with STORE

Table 22: SQL statements for querying and updating data

¹A dynamically compilable form exists for the SELECT statement
²These statements are also available for a dynamic cursor