The mi_scan_isolevel() accessor function
The mi_scan_isolevel() function retrieves the isolation level that the database server expects for the table that am_getnext scans.
Syntax
MI_ISOLATION_LEVEL mi_scan_isolevel(MI_AM_SCAN_DESC *scanDesc);- scanDesc
- Points to the scan descriptor.
Usage
If the access method supports isolation levels, it can call mi_scan_isolevel() from am_beginscan to determine the correct isolation level.
Call mi_scan_isolevel() to validate that the isolation level requested by the application does not surpass the isolation level that the access method supports. If the access method supports Serializable, it does not call mi_scan_isolevel() because Serializable includes the capabilities of all the other levels.
Return values
- MI_ISO_NOTRANSACTION
- Indicates that no transaction is in progress.
- MI_ISO_READUNCOMMITTED
- Indicates Dirty Read.
- MI_ISO_READCOMMITTED
- Indicates Read Committed.
- MI_ISO_CURSORSTABILITY
- Indicates Cursor Stability.
- MI_ISO_REPEATABLEREAD
- Indicates Repeatable Read.
- MI_ISO_SERIALIZABLE
- Indicates Serializable.