Isolation Level Constants (Database)

The following constants can be used anywhere in macros or scripts in place of the actual values.

If you are retrieving the value of a property or parameter, scripts or macros will return the integer value, whereas Inspector will display the constant equivalent.

KEEP IN MIND:

When using constants in the script editor, each constant must be prefaced by nl.

Constant

(Macros)

Constant

(Scripts)

Value

 

Description

DBXactUnspecified

nlDBXactUnspecified

-1

The record access is unspecified.

DBXactChaos

nlDBXactChaos

16

There is no commitment control for the connection.

DBXactReadCommitted

nlDBXactReadCommitted

4096

Every record accessed is locked. Records that are not updated or deleted are locked only until a different record is accessed. Records that are updated, added, or deleted are locked until the transaction is committed or rolled back. Corresponds to IBM commit lock level *CS.

DBXactReadUncommitted

nlDBXactReadUncommitted

256

Every record read for update is locked. If a record is updated, added, or deleted, that record remains locked until the transaction is committed or rolled back. Records that are accessed for update but are released without being updated are unlocked. Corresponds to IBM commit lock level *CHG.

DBXactRepeatableRead

nlDBXactRepeatableRead

65536

Every record accessed is locked until the transaction is committed or rolled back. Corresponds to IBM commit lock level *ALL.

DBXactSerializable

nlDBXactSerializable

1048576

Same as DBXactRepeatableRead.

See Also

IsolationLevel property


© 2004-2021 looksoftware. All rights reserved.