Archives of the TeradataForum

Message Posted: Wed, 18 Feb 2009 @ 20:57:29 GMT

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

<-- Anonymously Posted: Wed, 18 Feb 2009 15:49 -->

Long ago, if you specified LOCK ROW ACCESS but a table-level lock was required, Teradata would use LOCK TABLE READ. That has been fixed; LOCK ROW ACCESS results in table READ locks also being downgraded to ACCESS.

The problem Kiki referenced (which still exists) has to do with explicit LOCK modifiers in multi-statement requests. In particular, LOCK ROW is honored only if it appears within the last statement in the request.

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