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


Please Help Members By Posting Answers For Below Questions

How to connect to db2 database from windows command line?

562


Why cursor is used in db2?

575


What is host variable in db2 cobol?

604


What is innodb buffer pool?

564


What is a collection in db2?

584






What is meant by union and union all?

589


How to get the ddl of a table in db2?

679


What is null indicator in db2?

604


Which command is used to remove all rows from a table?

553


What happens in bind step in a db2 program?

569


What is view db2?

625


How can you quickly find out the # of rows updated after an update statement?

632


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

628


What are the 2 sqlcodes that are returned?

643


What is a system catalog table in db2?

588