Archives of the TeradataForum

Message Posted: Wed, 30 Nov 2005 @ 11:15:59 GMT

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

Probably the easiest way is to use bteq and a transaction.

Example

     Bt;
     Locking the_table for exclusive select * from the_table;

     /* In another bteq session (or mload) try running a select * from
     the_table and it will be blocked */

     Et;
     /* At this point the select in the second bteq will respond. */

Hope this helps

Glenn Mc

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