View, Designer

View Definition

In this section, you provide the definition for the view.

View name

Type a name for the view. The default name is VIEWn. You can type a new name for the view. Use quotation marks for delimited names. The name cannot exceed 128 characters, and must be unique among table and view names in the schema.

View schema

Select a schema for the view. By default, the value for this field is the name of the schema that is obtained from the current data connection. You can change the value of this field to another schema. If you leave this field blank, the designer reverts to the default value. Use quotation marks for delimited names.

Comment

Type one or more comments to be appended after the CREATE VIEW declaration.

Inserted or updated row conformance check

In this section, you specify the check constraints for the view. Select one of the following options:

• None - Specifies that the only check constraints for this view are inherited from its parent views. You can insert or update rows that do not conform to the definition of the view.
• Cascaded - Specifies that the search criteria that are used to define the view and the search criteria that are used to define any parent views (or other views from which it is descended) are used as a check constraint. These constraints are passed on to any child views.
• Local - Specifies that the search criteria that are used to define the view are used as a check constraint in addition to any check constraints that the view inherits from its parent tables. These constraints are also passed on to any child views.

Script

In this section, you enter the SQL code that defines the view. The designer permits only SQL SELECT statements.

Instead of SQL code, you can define the view with XQuery or SQLXML code.

Query Builder

Click this button to graphically build an SQL SELECT statement in the Visual Studio Query Builder. When you close the Query Builder, the SQL code in the Query Builder is automatically pasted in this editor at the insertion point.

Additional information is available in your DB2 documentation. You can also find information in DB2 SQL documentation that is available through The SQL Reference for Cross-Platform Development Web page on developerWorks.

Result Data

After you click the Execute button on the IBM View Designer toolbar, this section shows the columns and rows that comprise the view that you have defined in the script.