Set the Transaction Isolation Level for a Connection — odbcSetTransactionIsolationLevel • odbc

Set the Transaction Isolation Level for a Connection

odbcSetTransactionIsolationLevel(conn, levels)

Arguments

conn: A DBI::DBIConnection object, as returned by dbConnect().
levels: One or more of 'read_uncommitted', 'read_committed', 'repeatable_read', 'serializable'.

See also

https://learn.microsoft.com/en-us/sql/odbc/reference/develop-app/setting-the-transaction-isolation-level

Examples

if (FALSE) { # \dontrun{
# Can use spaces or underscores in between words.
odbcSetTransactionIsolationLevel(con, "read uncommitted")

# Can also use the full constant name.
odbcSetTransactionIsolationLevel(con, "SQL_TXN_READ_UNCOMMITTED")
} # }