DB2® Universal Database for OS/390® Version 7.1 Certification Guide

View Classification

Now that we have examined various SQL DML statements, let's take a closer look at views. We have already discussed creating views. Now we'll examine the different types of views. Views are classified by the operations they allow, but are generally referred to as either read-only or not read-only views. The referential and check constraints are treated independently. They do not affect the view classification.

For example, you may not be able to insert a value into a table because of a referential constraint. If you create a view using that table, you also cannot insert that value using the view. However, if the view satisfies the rules for a non read-only view, it will still be considered an insertable, updateable, or deleteable ...