The search-condition is applied to each row of the table or view and the deleted rows are those for which the result of the search-condition is true.
If the search-condition contains a subquery, the subquery can be thought of as being executed each time the search condition is applied to a row, and the results of the subquery used in applying the search condition. In actuality, a subquery with no correlated references may be executed only once, whereas a subquery with a correlated reference may have to be executed once for each row.
If a subquery refers to the object table of the DELETE statement or a dependent table with a delete rule of CASCADE, SET NULL, or SET DEFAULT, the subquery is completely evaluated before any rows are deleted.
The table or view identified must also be specified in the FROM clause of the select-statement of the cursor and the cursor must be deletable. For an explanation of deletable cursors, see DECLARE CURSOR.
When the DELETE statement is executed, the cursor must be positioned on a row; that row is the one deleted. After the deletion, the cursor is positioned before the next row of its result table. If there is no next row, the cursor is positioned after the last row.
Introduces the isolation level, which may be one of:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.