If I have a view which is a join of two or more tables, can
this view be updatable?
Answer Posted / mahesh vasudevan
One can not make update operation on a view that has a join
from more than two or more tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are host variables in db2?
Explain about rct.
What are the contents of dclgen?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is cascading rollback?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the reason behind not using select * in embedded sql programs?
What is the result of open cursor statement?
What does a deadlock mean in DB2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a db2 package?
what is the responsibility of the construction superintendent
What is the syntax for creating a table in the db2 database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is data manager?