Update and Delete Rows Using Cursors

If the cursor is updatable, use the update or delete statement to update or delete rows.

SAP ASE determines whether the cursor is updatable by checking the select statement that defines the cursor. You can also explicitly define a cursor as updatable, using the for update clause of the declare cursor statement.

• Update Cursor Result Set Rows
  You can use the where current of clause of the update statement to update the row at the current cursor position. Any update to the cursor result set also affects the base table row from which the cursor row is derived.
• Delete Cursor Result Set Rows
  Using the where current of clause of the delete statement, you can delete the row at the current cursor position.