Creating an Index
To create a new index:
|
1.
|
Click [Index] on the button bar or Select Data from the menu and choose Index to display the Index dialog. |
Note: When working with zSeries data (ISAM, VSAM, DB2 and IMS) with native keys, Analyzer indexing will not be available. Analyzer will automatically use the native index on the host system directly. For more information on native keys see Native and Key Fields.
|
2.
|
From the Index dialog, select a field from the “Index Key Fields” list box. |
|
3.
|
You can also click [Choose] to display the Selected Fields dialog, which gives you more information about the fields you are selecting. |
|
4.
|
There are three ways to select fields using the Selected Fields dialog: |
|
•
|
Click the name of the field to select it, then click the right arrow to move it between list boxes. |
|
•
|
Double-click the name of the field to select it and move it from the Available Fields list box to the Selected Fields list box. |
|
•
|
Click [Expression] to display the Expression Builder. The Expression Builder lets you apply a condition or filter to the data in the selected field. |
|
5.
|
Select the field you want from the Available Fields list box, then click [OK] to return to the Index dialog. |
|
6.
|
Enter a name for the index file in the Output File text box. |
|
7.
|
Click [OK] to close the dialog and execute the Index command. Analyzer lists the index in the Overview under the associated table layout and under Indexes. |
You can now use the Search command to access individual indexed records quickly. For more information see Search.
To learn more about activating and de-activating indexes, see Activating and Deactivating Indexes.