ASA Programming Guide
Three-Tier Computing and Distributed Transactions
Using distributed transactions
DTC has a set of isolation levels, which the application server specifies. These isolation levels map to Adaptive Server Anywhere isolation levels as follows:
| DTC isolation level | Adaptive Server Anywhere isolation level |
|---|---|
| ISOLATIONLEVEL_UNSPECIFIED | 0 |
| ISOLATIONLEVEL_CHAOS | 0 |
| ISOLATIONLEVEL_READUNCOMMITTED | 0 |
| ISOLATIONLEVEL_BROWSE | 0 |
| ISOLATIONLEVEL_CURSORSTABILITY | 1 |
| ISOLATIONLEVEL_READCOMMITTED | 1 |
| ISOLATIONLEVEL_REPEATABLEREAD | 2 |
| ISOLATIONLEVEL_SERIALIZABLE | 3 |
| ISOLATIONLEVEL_ISOLATED | 3 |