You can alter a view so that you can use the view as a source for
change capture.
Restrictions
You can alter a view for change capture only if the view meets all three
of these criteria:
- The view references only one table that is altered for change capture.
- The view references all of the columns in the base table and renames none
of the columns.
- The WHERE clause does not contain references to other tables.
- The view references an Adabas, CA-IDMS, CICS® VSAM, IMS™, or native VSAM table.
Procedure
To alter a view for change capture:
- To alter a view in a data design project:
- In the Data Project Explorer, select the view.
- On the General page of the Properties view, set the DATA CAPTURE
flag to CHANGES.
- Generate the DDL for the view and run the DDL on a data server.
- To alter a view that already exists in a metadata catalog:
- In the Database Explorer, expand the connection to your data
server until you locate the view.
- Right-click the view and select Enable Change Capture.
The change to the view takes effect immediately.