Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2005 @ 14:16:00 GMT

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

Hi Al,

Couple of ways come to mind...

1) run a Bteq script such as:

     .set session trans btet;
     .logon ????
     bt;

     locking table XXX for write;

     wait 1500;

This will lock and hold the lock for 1500 seconds.

2) use Queryman to do much the same thing.

     - logon to the dbms
     - bt;
     - locking table XXX for write;

and just let it sit there whilst you run your Mload script.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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