Archives of the TeradataForum

Message Posted: Thu, 22 Jul 1999 @ 17:10:04 GMT

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

You can now use a "LOCKING ROW FOR ACCESS" clause. I believe this was introduced in V2R3. This clause applies a single AMP hash lock if the query only needs to lock one row hash.

This is written-up in Chapter 18 of the DML documentation.

John

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