View properties are shown in the Properties view.
You can use the Properties view to display and modify
the properties of a view.
If the view already exists in a metadata catalog on a data server
and you want any changes that you make to the view to be reflected in the
metadata catalog, you must follow these steps:
- Drop the view from the metadata catalog. You can generate the DDL to drop
the view by right-clicking the view and selecting Generate DDL.
In the Generate DDL wizard, select the DROP
statements check box.
- Run the generated DDL on the data server.
- Make your changes to the view.
- Generate the DDL to create the view. You can generate this DDL by opening
the Generate DDL wizard and selecting the CREATE
statements check box.
- Run the DDL on the data server.
The Properties view for a view contains the following information:
- General page
- Name
- Displays the name of the view in an editable field.
- Schema
- Displays the schema that contains the view.
- Change capture
- Sets the DATA CAPTURE flag on the view. This field is available only if
the view meets all three of these criteria:
- The view references only one table.
- The view references all of the columns in the base table.
- The view references an Adabas, CA-IDMS, CICS® VSAM, IMS™, or native VSAM table.
- CHANGES
- Specifies to capture changes that are made to the data that the view references.
- NONE
- Specifies not to capture changes that are made to the data that the view
references.
- Columns page
- Lists the columns that are referenced in the view.
- SQL page
- Displays the SELECT statement for the view in an editable field. Click
the Validate button to check the statement for syntax
errors.
- Privileges page
- Lists that privileges that are granted on the view. Click the add button
(
) to add privileges.
Click the delete button (
) to remove privileges.
- Documentation page
- Lets you add comments to the view.