Identifying Key Fields in an Index

Because the key fields available for accessing a record are determined by the index used, you frequently need to know which fields are present in the index. The following set of steps describes one method for identifying the fields in an index.

  1. At the command line, type

    dbdef

  2. In the Product Line field, type or select the product line with the index you want to search.
  3. Press Define (F6) and choose Files.
  4. In the File Name field, type or select the name of the file you want to search.
  5. Press Define (F6) and choose Indexes.
  6. In the Index Name field, type or select the name of the index you want to search.

    The list of key fields in the index displays the key fields used by this index to access the file.

    For more information on key fields and indexes, see the Application Development Workbench.