CursorUpdate
database parameter
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
|
1 |
CursorUpdate=value |
|
Parameter |
Description |
|---|---|
|
value |
A number that specifies whether database cursors
|
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):
|
1 2 |
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:
1SQLCA.DBParm="CursorUpdate=1"