Are views updatable ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scrollable cursor in db2?

583


What is temporal table in db2?

603


What r the comman abends in db2, jcl and cobol???????

1820


What is a system catalog table in db2?

588


What is the use of db2?

586






What is db2 plan table?

622


What is phantom read in db2?

638


What is the difference between cursor and select statement?

615


Which component is responsible for db2 startup and shutdown?

630


How can we retrieve the total number of records in RPG & CLLE?

197


What is difference between alias and synonym in db2?

643


What is commit in db2?

596


What is the physical storage length of date data type?

732


What is copy pending and check pending in db2?

578


How will you return the number of records in table?

516