dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2ConnectionStringBuilder Class / IsolationLevel Property

In This Topic
    IsolationLevel Property (DB2ConnectionStringBuilder)
    In This Topic
    Gets or sets the isolation level for the connection.
    Syntax
    'Declaration
     
    Public Property IsolationLevel As String
    public string IsolationLevel {get; set;}

    Property Value

    The isolation level for the connection. The default value is "SQL_TXN_READ_COMMITTED".
    Remarks

    If the application specifically sets the isolation level for a connection or statement handle, then this property will have no effect on that handle.

    Acceptable values:

    • SQL_TXN_READ_UNCOMMITTED - Read Uncommitted (Uncommitted read)
    • SQL_TXN_READ_COMMITTED - Read Committed (Cursor stability)
    • SQL_TXN_REPEATABLE_READ - Repeatable Read (Read Stability)
    • SQL_TXN_SERIALIZABLE - Serializable (Repeatable read)
    See Also