Requirements for updatable cursors

Only specific SELECT statements- simple accesses of a single table-allow you to update or delete rows as you step through them.

For more information, see "SELECT statement" and "FOR UPDATE clause" in the Derby Reference Manual.

Related tasks
Naming or accessing the name of a cursor
Related reference
Extended updatable cursor example