View previous topic :: View next topic
|
Author |
Message |
shchan
New User
Joined: 06 Jun 2007 Posts: 58 Location: Hyderabad
|
|
|
|
Hi,
Can anybody clarify if a view can be updated and if so, will the base table also be updated? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
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. |
|
Back to top |
|
|
|