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


Altering views to support change capture

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:

Related concepts
Mapping data for change capture
Creating views on existing tables
Related tasks
Creating Adabas tables and views for change capture
Creating CA-IDMS tables and views for change capture
Creating CICS VSAM tables and views for change capture
Creating IMS tables and views for change capture
Creating native VSAM tables and views for change capture
Altering tables to support change capture


Feedback

Update icon Last updated: 2006-12-15