Can I use LOCK TABLE on a view?
Answer / s
You can use LOCK TABLE on any table. View is not a
physical object.
| Is This Answer Correct ? | 4 Yes | 2 No |
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
How do I add a column in db2?
Can you search give an array in the WHERE clause of a db2 query?
what needs to be done if a table is in copy pending / check pending status?
What are the three DB2 date and time data types and their associated functions?
What is blu acceleration in db2?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How to insert more than one record using insert?
How many databases are there?
How do you prepare a COBOL + DB2 program from coading till execution ?
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 ?
What is lock escalation?