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
Where are plans stored?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to define the data items to receive the fetch items for the SQL?
What is copy pending status in db2?
How do I delete a column in db2?
what is a plan and how do you refer the plan in the program?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
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?
What is buffrpool? Where we use it ?
what is the input to PLAN? what is the input to DBRM?
What are data types?
What is the purpose of rollback and commit?