Archives of the TeradataForum

Message Posted: Tue, 06 Jun 2007 @ 01:21:10 GMT

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

Hi,

You could do some thing like the following

     BEGIN TRANSACTION;

     Locking table  db.tableName1 for read;
     Locking table  db.tableName2 for read;
     Locking table  db.tableName3 for read;

     Do SQL/DML stuff1;
     Do SQL/DML stuff2;

     END TRANSACTION;

Fachtna O'Donovan AIB Bank
Ireland

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