Are views updatable ?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
Not all of them. Some views are updatable e.g. single table
view with all the fields or mandatory fields. Examples of
non-updatable views are views which are joins, views that
contain aggregate functions (such as MIN), and views that
have GROUP BY clause.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / shankar
Yes but only for those views which are created with UPDATE
option.
| Is This Answer Correct ? | 5 Yes | 4 No |
how can u understand the end of the table ?
What is the advantage in De-normalizing tables in DB2?
what is sql abend code -801,-802?
What is cascading rollback?
Compare a subselect to a join?
is it compulsory commitment control in journal?
What do you mean by rollback?
How is a typical DB2 batch program executed ?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Is db2 a programming language?
Can one database have multiple instances?
Why db2 is called db2?