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.