UPDATE_ISOLATION_LEVEL=

UPDATE_ISOLATION_LEVEL=

Specifies which level of read isolation locking to use when updating data.

Default value: 1

Syntax
Details

Syntax

UPDATE_ISOLATION_LEVEL=1 | 3

1: indicates that the SYBASE default cursor isolation level is used.
3: indicates that SYBASE cursor isolation level 3, which uses serialized reads, is used.

Details

SYBASE uses a shared or update lock on base table pages that contain rows representing a current cursor position. This option applies only when UPDATE_LOCK=PAGE. Refer to your SYBASE documentation for more information.

Note: This option applies to updates only when UPDATE_LOCK_TYPE=PAGE because cursor updating is in effect. It does not apply when UPDATE_LOCK_TYPE=NOLOCK. [cautionend]

UPDATE_ISOLATION_LEVEL= can also be specified with the CURSOR_ISOLATION_LEVEL=, CURSOR_ISO_LVL=, UPD_ISO_LVL= and U_ISOLVL= aliases.

Chapter Contents
Previous
Next
Top of Page