Isolation Level and Access Locking - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

Isolation Level and Access Locking

 

Table 39: Isolation Level and Access Locking

IF a transaction starts with the isolation level set to...

THEN OLE DB Provider for Teradata...

ISOLATIONLEVEL_READUNCOMMITTED,

adds an ACCESS locking modifier to SELECT statements submitted during the transaction.

ISOLATIONLEVEL_SERIALIZED,

allows Teradata Database to determine the locking mode.