The mi_tab_isolevel() accessor function
The mi_tab_isolevel() function retrieves the isolation level that the SET ISOLATION or SET TRANSACTION statement applies.
Syntax
MI_ISOLATION_LEVEL mi_tab_isolevel(MI_AM_TAB_DESC *tableDesc)- tableDesc
- Points to the table descriptor.
Usage
If the access method supports isolation levels, it can call mi_tab_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_tab_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.