To understand what is going on with these cursor deletes and updates in SUR, could you explain what is done to execute each. For example for a delete there could be: 1) position on rowlocation and just do delete 2) position on rowlocation and check that all other fields match the row being deleted and do the delete 3) execute delete from x where (provide matching columns for all columns).
There are similar options for update.
