WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


View properties

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:

  1. 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.
  2. Run the generated DDL on the data server.
  3. Make your changes to the view.
  4. 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.
  5. 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 (Plus sign) to add privileges. Click the delete button (Delete button) to remove privileges.
Documentation page
Lets you add comments to the view.
Related concepts
Creating views on existing tables
Related tasks
Adding or replacing columns in tables based on copybooks
Modifying the selection of records in tables for CA-IDMS databases
Mapping tables and creating publications for Classic event publishing
Mapping tables for Classic federation
Mapping tables for Classic replication
Related reference
Column properties
Database properties
Publication properties
Publishing queue map properties
Table properties
Index properties
Stored procedure properties


Feedback

Update icon Last updated: 2006-12-15