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


Index properties

Index properties are shown in the Properties view. You can use the Properties view to view or modify the properties of an index.

If the index already exists in a metadata catalog on a data server and you want any changes that you make to the index to be reflected in the metadata catalog, you must follow these steps:

  1. Drop the index from the metadata catalog. You can generate the DDL to drop the index by right-clicking the index 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 index.
  4. Generate the DDL to create the index. 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 an index contains the following information:

General page
Allows you to change the name of the index.

If the index is an alternate index for a CICS® VSAM table, the FCT name field displays the name of the CICS table that contains the information used by CICS file control for accessing the VSAM file.

In the index is an alternate index for a VSAM table, these controls appear:

DS
Specifies that the information from which to create the index is contained in a data set.
DD
Specifies that the information from which to create the index is contained in a data set with a DD name.
Name
Type the name of the data set or DD card in which the information for the index is located.
Details page
Lists the columns that are in the index. You can modify this list.
PCB selection page (for IMS™ only)
Displays the method that Classic federation will use to select PCBs for accessing the index.
Documentation
Lets you add comments to the index.
Related tasks
Adding or replacing columns in tables based on data definition files
Modifying the selection of records in tables for CA-IDMS databases
Creating indexes
Related reference
Column properties
Database properties
Stored procedure properties
Table properties
View properties


Feedback

Update icon Last updated: 2007-07-11