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 indexes

After you define a table, you can define indexes on the table to map existing indexes on the underlying data. An index identifies columns in a table that correspond to a physical index that is defined against a data source. Indexes are supported for Classic federation, but not for Classic event publishing or Classic replication.

Procedure

To create an index:

  1. In the Data Project Explorer, right-click the table that you want to define an index on and select Add Classic Object > Index. The New Index wizard opens.
  2. Name the index, specify whether it should be unique, and select the columns to base the index on.
  3. If the index is for an IMS™ table, specify the method that Classic federation can use to select a PCB to access your IMS database.
  4. If the index is for a CICS® VSAM or native VSAM table, specify the DS or DD name for the index.
Related concepts
Mapping data for Classic federation
Related tasks
Creating tables and views for DB2 for z/OS databases
Creating sequential tables and views for Classic federation
Creating stored procedures
Modifying the PCB selection for IMS tables or indexes
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
Related reference
Index properties


Feedback

Update icon Last updated: 2007-07-11