If I have a view which is a join of two or more tables, can
this view be updatable?
Answer Posted / guest
If view has join that time view can not be updatable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which isolation level provides maximum concurrency?
what is the responsibility of the construction superintendent
What is db2 connect?
What is load utility 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 ?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the role of schema in the db2 database?
What is concurrency?
How can deadlocks be resolved?
What is db2 plan table?
How will you return the number of records in table?
What is a db2 collection?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to access db2 tables in mainframe?
Highlight all the advantages that are attached to a package.