CursorUpdate database parameter
Description
For those interfaces that support it, CursorUpdate specifies
whether cursors in your target database are declared read-only or
updatable.
Controls
-
DIR Sybase DirectConnect
-
ASE, SYC, and SYJ SAP Adaptive Server Enterprise
Syntax
|
1 |
CursorUpdate=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
A number that specifies whether database
|
Default
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 |
DELETE FROM <span>table</span> WHERE CURRENT OF <span>cursor</span><br>UPDATE <span>table</span> SET <span>set_clause</span> WHERE CURRENT OF <span>cursor</span> |
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.DbParameter="CursorUpdate=1"