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
Define check constraint.
How would you find out the total number of rows in a db2 table?
What is the usage of open cursor command?
What are packages in db2?
How do I start db2 in windows?
If I have a view which is a join of two or more tables, can this view be updateable?
What is runstats db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are db2 tables?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is db2 stogroup?
Before you give the explain statement, what are the prerogatives?
Explain about open switch business continuity software?
What is consistency token in db2?
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 ?
