Adaptive Server Enterprise, SAP SQL Anywhere, and SAP 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 SAP Sybase IQ, updatable cursors are asensitive only, for one table only, and chained only. Updatable hold cursors are not permitted. Updatable cursors in SAP Sybase IQ get a table lock.