Link to this page
Print this page
Parent topic
:
SQL support
SQL support
Positioned updates/deletes
Describes row modification based on a FOR UPDATE cursor.
Understanding positioned update or delete
DECLARE (SELECT ... FOR UPDATE)
Associate a database cursor with a
SELECT
statement to perform positioned updates and deletes
UPDATE ... WHERE CURRENT OF
Updates the current row in a result set of a database cursor declared for update.
DELETE ... WHERE CURRENT OF
Deletes the current row in a result set of a database cursor declared for update.
Examples