update isolation

Arguments

Level is one of the following:

• uncommitted read | ur
• cursor stability | cs
• read stability | rs
• repeatable read | rr
• serializable | sl

Note:  These names are defined by the SQL-92 standard. The names employed by different databases do not always correspond to these names. For example, DB2 defines repeatable read as serializable and read stability as repeatable read. Consult your database documentation for the terminology used by your database.

Use

Description

Use this setting when the lock isolation connector option is set to uncommitted read or cursor stability, which are levels that do little locking.

Set update isolation level to read stability or repeatable read to have the lock ProcScript statement lock all modified records.

Note:  Although the update isolation option accepts and applies all isolation levels, only repeatable read or read stability will have any effect.

When no update isolation level is specified, read stabilty is the default. This causes all records that you modify to get locked by default when cautious locking is in effect.

To prevent other Uniface processes that are waiting for a lock to be released from waiting indefinitely, use the maxlockwait setting to define a timeout value. When that time has expired, the user will receive an error message and can then continue.