Archives of the TeradataForum

Message Posted: Wed, 07 Aug 2013 @ 12:32:08 GMT

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

Paul GRAHAM wrote:

Just add another LOCKING:

     LOCKING TABLE a FOR ACCESS
     LOCKING TABLE b FOR ACCESS
     SELECT

Btw, i would prefer LOCK ROW ACCESS instead:

no need for adding all table names and it automatically upgrades to a table lock when neccessary.

In very old releases there used to be some problems with this approach (in some cases the row lock was upgraded to a table lock with READ instead of ACCESS), but now only some rare combinations in multi statemnet requests might show that behaviour (if at all).

Dieter

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