Interested to Buy Any Domain ? << Click Here >> for more details...
If I have a view which is a join of two or more tables, can
this view be updatable?
- 3 Answers
- 7459 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
If view has join that time view can not be updatable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is the difference between base table and view?
What information can you find in SYSIBM.SYSLINKS table?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is PRIME TABLE and what are the uses of it
What is difference between *omit and *nopass?
How is deadlock resolved?
What does reorg do in db2?
what is static sql? what is dynamic sql? Give me details
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
COBOL 
