Row-level cursor operations

All three products support the use of cursors with UPDATE and DELETE as follows:

UPDATE WHERE CURRENT OF {cursor}
DELETE WHERE CURRENT OF {cursor}

In Sybase IQ, updatable cursors are asensitive only, for one table only, and chained only. Updatable hold cursors are not permitted. Updatable cursors in Sybase IQ get a table lock.