For those interfaces that support it, CursorUpdate specifies whether cursors in your target database are declared read-only or updatable.
DIR Sybase DirectConnect
ASE, SYC, and SYJ Sybase Adaptive Server Enterprise
CursorUpdate=value
CursorUpdate=0
Set the CursorUpdate parameter to 1 to declare updatable cursors if you plan to use either of the following SQL statements in your application (table represents the table name and cursor represents the cursor name):
DELETE FROM table WHERE CURRENT OF cursor UPDATE table SET set_clause WHERE CURRENT OF cursor
If you are communicating with the database in a PowerBuilder script, you can reset the CursorUpdate value anytime before or after the Transaction object has connected to the database.
When you declare cursors updatable in a database accessed through DirectConnect, the cursor declaration you code must include a FOR UPDATE OF column_list clause.
When you use updatable cursors with the DIR interface and a Gatewayless connection to the mainframe, you must set Block=1 before executing the cursor. You can reset the Block parameter to its default of 100 after you close the cursor within your code.
To specify that database cursors are declared updatable:
Database profile Select the Cursors Declared Updatable check box on the Transaction page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="CursorUpdate=1"
