Can I use LOCK TABLE on a view?

Answer Posted / s

You can use LOCK TABLE on any table. View is not a
physical object.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1818


Are views updateable?

645


How to fetch the last row from the table in SQL (db2)?

1039


What does db2 stand for?

598


How do I add a column to a table in db2?

620






What does reorg do in db2?

578


What is dclgen (declaration generator)?

603


What is the purpose of rollback and commit?

595


What is an instance database?

602


What is the usage of open cursor command?

599


Explain about mirror activator disk mirroring?

560


What is a collection in db2?

584


How would you find out the total number of rows in a db2 table?

579


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2688


What is cursor with hold option in db2?

612