Hi all,

How we can upgrade and downgrade the locks in Teradata

can any body explain on it...

Thanks in Advance....

Re: locks

Locking is a kind of protection mechanism for the data access. We have Table level, database level and row level. We have 4 types of locks Exclusive, write,read and access locks.

I think all Locks cannot be downgraded for example write locks cannot be downgraded to read locks etc.,

But ,If you want you can override the default locks by explicitly specifying the locking modifier in your query.Please keep in mind regarding the restrictions on over riding the locks