Description
For those interfaces that support it, CursorUpdate specifies whether cursors in your target database are declared read-only or updatable.
Applies to
DIR SAP DirectConnect
ASE and SYC SAP Adaptive Server Enterprise
Syntax
CursorUpdate=value
|
Parameter |
Description |
|---|---|
|
value |
A number that specifies whether database cursors are declared read-only or updatable. Values are:
|
Default value
CursorUpdate=0
Usage
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.
Examples
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"
