Programming Considerations - 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

Programming Considerations

  • OLE DB Provider for Teradata only supports the functionality provided by Teradata.
  • The ITransactionLocal::StartTransaction method supports many isolation levels. However, OLE DB Provider for Teradata only supports the following isolation levels:
  • ISOLATIONLEVEL_READUNCOMMITTED
  • ISOLATIONLEVEL_SERIALIZED

    • The other isolation levels are either unsupported or are upgraded to one of the above levels. The following chart shows the remaining isolation levels and the level to which they are upgraded:

     

    Table 38: Upgrades to Isolation Levels 

    Isolation Level

    Upgraded To

    ISOLATIONLEVEL_BROWSE

    ISOLATIONLEVEL_READUNCOMMITTED

    ISOLATIONLEVEL_CHAOS

    ISOLATIONLEVEL_READUNCOMMITTED

    ISOLATIONLEVEL_CURSORSTABILITY

    ISOLATIONLEVEL_SERIALIZED

    ISOLATIONLEVEL_ISOLATED

    ISOLATIONLEVEL_SERIALIZED

    ISOLATIONLEVEL_READCOMMITTED

    ISOLATIONLEVEL_SERIALIZED

    ISOLATIONLEVEL_REPEATABLEREAD

    ISOLATIONLEVEL_SERIALIZED

    ISOLATIONLEVEL_UNSPECIFIED

    Not supported by OLE DB Provider for Teradata