Consider I have a View that is merely a simple join between 2 tables, selecting all columns.
The View is Updatable and Insertable.
What would be the locking behavior when executing an
INSERT statement in the following situations:
- I’m going to insert a record into the view, and only columns of table A have values.
- I’m going to update a record in the view, but only columns from table B were modified.
My doubt is basically if on situation 1, only table A is going to be locked, and if on situation 2, only table B is going to be locked.
I’ve searched for the answer in IBM’s documentation, but couldn’t find an appropriate answer. If possible, I'd like to know where IBM is keeping this information.