Locking Table for Share

Database
Enthusiast

Locking Table for Share

Can anyone tell me something about locking modifier "LOCKING ROW/TABLE/DATABASE FOR SHARE".  Is it same as READ lock??

locking table student.employee for share

select * from student.employee;

  1) First, we lock a distinct student."pseudo table" for read on a

     RowHash to prevent global deadlock for student.employee. 

  2) Next, we lock student.employee for read.

2 REPLIES
Teradata Employee

Re: Locking Table for Share

Yes, SHARE is a (deprecated) synonym for READ.

Enthusiast

Re: Locking Table for Share

Thanks Fred :)