Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Suggest you do some reading in the sql reference manual for your releaseof db2. Your understanding of a view is incorrect. . . Suggest you click on the "IBM Manuals" link at the top of the page and proceed form there.
A view is not a table - it is based on a table. There is no "base" table and then some other "thing" for the view. If a view is updated, the update occurs in the table on which the view is based.