Archives of the TeradataForum

Message Posted: Wed, 26 Oct 2005 @ 08:08:11 GMT

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

I am just curious, did you consider creating a "lock table" and precede your query with a locking for write clause? You wouldn't even need to have any rows in the table.

For example something like this:

     Locking Table KEY_TABLE FOR WRITE
     Query1
     ;Query2
     ;Query3
     ;

Doing this would eliminate the loop, get the lock as soon as the preceeding process had completed and wouldn't use as many CPU cycles?

Regards

Glenn Mc

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