Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ support the use of cursors with UPDATE and DELETE.
Consider this example:
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.