public System.Data.IsolationLevel IsolationLevel [ get]
This property represents the transaction isolation level. This property is Read-Only.
There are several isolation level options; the following list shows the possible values for IsolationLevel and the corresponding AS/400 isolation levels:
- Chaos *NONE
- ReadCommitted *CS
- ReadUncommitted *CHG
- RepeatableRead *ALL
- Serializable *ALL (*RR not supported)
- Unspecified *CS
To know all details about differences between *CS, *CHG and *ALL, you can consult the online help of the LCKLVL parameter of the STRCMTCTL command on the AS/400.
In summary :
• *NONE means that the transaction has no effect
• *CS means that all records changed inside a transaction remain locked. The records that are read during the transaction are locked only during the fetch (only the current record can be locked). The record changes (uncommitted) cannot be seen from other jobs until the transaction is committed.
• *CHG means that records changed inside a transaction remain locked. The records that are read for update are locked. If the record is not modified (or removed or added) the record is unlocked. The record changes (uncommitted) can be seen from other job when being inside the transaction.
• *ALL means that all fetched records during the transaction are locked, even if not modified. The record changes (uncommitted) cannot be seen from other jobs until the transaction is committed.
• *RR means that all objects implied by the transaction are completely locked. The record changes (uncommitted) cannot be seen from other jobs until the transaction is committed.