If I have a view which is a join of two or more tables, can this view be updateable?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

Where are plans stored?

2 Answers  


If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


What is copy pending status in db2?

0 Answers  


How do I delete a column in db2?

0 Answers  






what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,


when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


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?

1 Answers   IBM,


What is buffrpool? Where we use it ?

2 Answers   Tesco,


what is the input to PLAN? what is the input to DBRM?

4 Answers  


What are data types?

2 Answers  


What is the purpose of rollback and commit?

0 Answers  


Categories