Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 15:39:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The plan is that the database will support session level isolation specification in V2R6.1. Only read uncommitted (access lock) and serializable (read lock) will be supported. This capability will be leveraged by the various client APIs (ODBC, JDBC) using the existing API isolation specification.

The current ODBC driver implements the SQLSetConnectOption SQL_TXN_ISOLATION and only supports SQL_TXN_ SERIALIZABLE and SQL_TXN_READ_UNCOMMITTED. The ODBC implementation works by rewriting the query to place the locking for access modifier. There are limits on this approach, for example it does not recognize subqueries.

Mike

	<Prev	Next>		<<First	<Prev	Next>	Last>>