If I have a view which is a join of two or more tables, can
this view be updatable?
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 |
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is runstats db2?
What is the use of value function?
Explain about mirror activator disk mirroring?
How can we read records for specific member in CL? AND rpg?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What are column-name qualifiers used?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Can we delete records from view?
How can you quickly find out the # of rows updated after an update statement?
What is a page in db2?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.