Positioned Deletions

Positioned deletions use cursors and therefore apply to only static or dynamic SQL, but not to interactive SQL. You can use a positioned deletion if:

  • A cursor is within the current module or one of its compilation unit emulations that references the table
  • This cursor has been opened within the current transaction
  • This cursor has had at least one row fetched
  • The cursor has not yet been closed

The last row fetched is deleted.