Locking the table

Database
Enthusiast

Locking the table

Hi,

  I have a requirement,i have to run multiple SQL statements but i need to make sure no one can access the table while running these sqls.How i can achieve this.

Ex:

BT

select * from tableA;

update tableA set col1='xyz' where col2=2;

ET

1 REPLY
Enthusiast

Re: Locking the table

You can have a look ath this link where you can place lock, within BT -ET

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1146_111A/ch03...