Create View -- Fields and controls

View schema

View name

SQL statement

Clear

Undo

Check options

Comment

OK

Show SQL

Cancel

View schema

Use this box to specify the schema of the view that you're creating. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

• Click on the down arrow to display a list of existing schemas and select one.

• Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, it can be a new one. This name:

  • Can contain from 1 to 8 characters

  • Cannot be one of the following reserved schema names:
    • SYSCAT
    • SYSFUN
    • SYSIBM
    • SYSSTAT

  • Can be an ordinary or delimited identifier

View name

Type a name for the view that you are creating. This name:

• Can contain from 1 to 128 characters
• Can be an ordinary or delimited identifier

Attention: This name must be unique within the view's schema. No other object in the schema can have the same name.

SQL statement

This field displays an SQL template for a CREATE VIEW statement. To create a view, type in your own SQL statement, or type in the appropriate SQL according to the template.

Examples

(projno, projname, in_charge)
AS
SELECT projno, projname, respemp
FROM project
WHERE substr(projno, 1,2)='MA'

Clear

Click on this push button to clear any text in the SQL statement box.

Undo

Click on this push button to remove the last change made to the SQL statement box.

Check options

Use the Check options radio buttons to specify the constraint that conforms to the definition of the view. A row that does not conform to the definition of the view is a row that does not satisfy the search conditions of the view. If a check option is specified for an updatable view that does not allow inserts, then the constraint applies to updates only.

Select one radio button to specify the check option you want for the view:

None

The definition of the view is not used in the checking of any insert or update operations that use the view. Because the definition of the view is not used, rows might be inserted or updated through the view that do not conform to the definition of the view.

Cascaded

Specifies the constraint on a new view such that the new view inherits the search conditions as constraints from any updatable view on which the new view is dependent. Every updatable view that is dependent on the new view is also subject to these constraints. Thus, the search conditions of the new view and each view on which the new view is dependent are ANDed together to form a constraint that is applied for an insert or update of the new view or of any view dependent on the new view.

Local

Specifies the constraint on a view V such that the search condition of V is applied as a constraint for an insert or update of V or of any view that is dependent on V.

Comment

Type a comment of up to 254 characters, including embedded blanks, in this box.