Updating or deleting a row

If you are using an updatable cursor, you can update or delete a row in the base table upon which the cursor description is based after you have positioned the cursor. To do this, use the UPDATE...WHERE CURRENT OF or DELETE...WHERE CURRENT OF statement.

The update or delete operation refers to the row in the cursor table on which the cursor is currently positioned. The position of the cursor is not changed by an update operation. After a delete operation, the cursor is positioned on the next row in the cursor table (or after the last row, if the end of the table has been reached. You must reposition the cursor with FETCH before you can perform another update or delete operation.