View properties

Properties for IBM® data server view objects

For more information about view syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Check type Specifies a value for the WITH...CHECK OPTION clause. Available options are NONE, CASCADED, or LOCAL.
NONE
The definition of the view is not used in the checking of any insert or update operations that use the view.
CASCADED
This view inherits the search conditions as constraints from any updatable view on which this view is dependent. Furthermore, every updatable view that is dependent on this view is also subject to these constraints. Thus, the search conditions of this view and each view on which this view is dependent are ANDed together to form a constraint that is applied for an insert or update of this view or of any view dependent on this view.
LOCAL
The search condition of this view is applied as a constraint for an insert or update of this view or of any view that is dependent on this view.
Columns page
Shows the columns that are included in the view.
SQL page
Shows the SQL source for the view.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.
Related information
CREATE VIEW statement syntax, Version 9.1 for z/OS
CREATE VIEW statement syntax DB2 Version 9.1 for Linux, UNIX, and Windows
CREATE VIEW statement syntax, IBM Informix Dynamic Server v10.0

Feedback