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


Creating views on existing tables

You can create a view on a table that already exists in a data design project, with the SQL builder, with the SQL editor, or with the Properties view.

If you create a view that you want to use for a publication or subscription, remember to alter the view to support change capture.

Related tasks
Creating views on existing tables with the SQL builder
Creating views on existing tables with the SQL editor
Creating views on existing tables with the Properties view
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
Creating Adabas tables and views for Classic federation
Creating CA-Datacom tables and views for Classic federation
Creating CA-IDMS tables and views for Classic federation
Creating CICS VSAM tables and views for Classic federation
Creating IMS tables and views for Classic federation
Creating VSAM tables and views for Classic federation
Creating sequential tables and views for Classic federation
Altering views to support change capture
Generating DDL
Exporting SQL to remote z/OS hosts
Related reference
View properties
Related information
Views


Feedback

Update icon Last updated: 2007-07-11