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
What is the difference between bind and rebind in db2?
How to execute stored procedure in db2 command editor?
What is the function of logging in the db2 database?
Name the various locking levels available?
List out the three types of page locks that can be held.
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 ?
Explain how can you do the explain of a dynamic sql statement?
Define check constraint.
What is netezza database?
Explain the function of data manager.
What r the comman abends in db2, jcl and cobol???????
Mention the location where the output received from explain statement is stored.
How do you find the maximum value in a column in db2?
How to check sequence on a table in db2?
What are the contents of dclgen?
