4. Data Manipulation SQL

This chapter explains the syntax and structure of the data manipulation SQL.

Organization of this chapter
General rules
ALLOCATE CURSOR statement Format 1 (Allocate a statement cursor)
ALLOCATE CURSOR statement Format 2 (Allocate a result set cursor)
ASSIGN LIST statement Format 1 (Create list)
ASSIGN LIST statement Format 2 (Create list)
CALL statement (Call procedure)
CLOSE statement (Close cursor)
DEALLOCATE PREPARE statement (Nullify the preprocessing of SQL)
DECLARE CURSOR Format 1 (Declare cursor)
DECLARE CURSOR Format 2 (Declare cursor)
DELETE statement Format 1 (Delete rows)
DELETE statement Format 2 (Delete row using an array)
Preparable dynamic DELETE statement: locating (Delete row using a preprocessable cursor)
DESCRIBE statement Format 1 (Receive retrieval information and I/O information)
DESCRIBE statement Format 2 (Receive retrieval information and I/O information)
DESCRIBE CURSOR statement (Receive cursor retrieval information)
DESCRIBE TYPE statement (Receive definition information on user-defined data type)
DROP LIST statement (Delete list)
EXECUTE statement Format 1 (Execute SQL)
EXECUTE statement Format 2 (Execute an SQL statement using an array)
EXECUTE IMMEDIATE statement (Preprocess and execute SQL)
FETCH statement Format 1 (Fetch data)
FETCH statement Format 2 (Fetch data)
FETCH statement Format 3 (Fetch data)
FREE LOCATOR statement (Invalidate locator)
INSERT statement Format 1 (Insert row)
INSERT statement Format 2 (Insert row)
INSERT statement Format 3, Format 4 (Insert row using an array)
OPEN statement Format 1 (Open cursor)
OPEN statement Format 2 (Open cursor)
PREPARE statement (Preprocess SQL)
PURGE TABLE statement (Delete all rows)
Single-row SELECT statement (Retrieve one row)
Dynamic SELECT statement Format 1 (Retrieve dynamically)
Dynamic SELECT statement Format 2 (Retrieve dynamically)
UPDATE statement Format 1 (Update data)
UPDATE statement Format 2 (Update data)
UPDATE statement Format 3, Format 4 (Update row using an array)
Preparable dynamic UPDATE statement: locating Format 1 (Update data using a preprocessable cursor)
Preparable dynamic UPDATE statement: locating Format 2 (Update data using a preprocessable cursor)
Assignment statement Format 1 (Assign a value to an SQL variable or SQL parameter)
Assignment statement Format 2 (Assign a value to an embedded variable or a ? parameter)