Sybase IQ now supports updating or deleting a row at the current position of a cursor using the WHERE CURRENT OF CURSOR cursor-name clause of the UPDATE or DELETE statement. The PUT statement inserts a new row in a cursor. The DECLARE CURSOR statement supports the FOR UPDATE OF column-name-list syntax. Sybase IQ supports only type of cursor sensitivity, asensitive, and ignores requests for other types.Updatable cursors are supported from ODBC using the SQLSetPos statement with UPDATE, DELETE, and INSERT.
A new database option, FORCE_UPDATABLE_CURSORS, specifies that cursors that have not been declared as updatable can be updated. This option allows updatable cursors to be used in front-end applications without specifying the FOR UPDATE clause of the DECLARE CURSOR statement.
For more information on updatable cursor support, see DECLARE CURSOR statement [ESQL] [SP], UPDATE (positioned) statement [ESQL] [SP], PUT statement [ESQL], and DELETE (positioned) statement [ESQL] [SP] in Chapter 6, “SQL Statements” and “FORCE_UPDATABLE_CURSORS option” in Chapter 2, “Database Options” of the Sybase IQ Reference Manual.
