Create View -- Fields and controls

Column

AS

WITH

Check option - cascaded

Check option - Local

Column

This clause names the columns in the view.

If you specify a list of column names, it must consist of as many names as there are columns in the result table of the subselect (AS clause). Each name must be unique and unqualified.

If you do not specify a list of column names, the columns of the view inherit the names of the columns of the result table of the subselect. You must specify a list of column names if the result table of the subselect has duplicate column names or an unnamed column (a column derived from a constant, function, or expression that was not given a name by the AS clause).

AS

This clause defines the view. At any time, the view consists of the rows that would result if the subselect were executed.

WITH

Specifies the constraint that every row that is inserted or updated through the view must conform to the definition of the view. DB2 enforces this constraint whenever rows of the view are inserted or updated. If the search condition is not true for an inserted or updated row, an error occurs and no rows are inserted or updated. If a Check Option is not specified, the search condition of the view is not used to check any insert or update operations that use the view. Rows that do not conform to the definition of the view can be inserted or updated, but then the rows are not accessible through the view (SELECT * FROM V).

Check option - Cascaded

Select this radio button to specify that update and insert operations on a view must satisfy the search conditions of that view and all underlying views, regardless of whether the underlying views were defined with a check option. Furthermore, every updatable view that is directly or indirectly defined on the view inherits those search conditions (the search conditions of the view and all underlying views of ) as a constraint on insert or update operations.

Check option - Local

Select this radio button to specify that the local check option let you update or insert rows that do not conform to the search condition of the view. You can perform these operations if the view is directly or indirectly defined on a view that was defined without a check option.