INSTEAD OF Triggers - All Views are Updatable!

From the developerWorks archives

Serge Rielau

Date archived: May 11, 2017 | First published: October 10, 2002

Views are commonly used to separate the logical DB2 schema from the physical schema. This article assesses which views are updatable on their own, and then introduces a feature new with DB2 UDB V8.1 called INSTEAD OF triggers which makes all views updatable.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some content, steps, or illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=13622
ArticleTitle=INSTEAD OF Triggers - All Views are Updatable!
publish-date=10102002