For word indexing to work as expected, the word-break table ABL uses to write the word indexes (to add, modify, or delete a record that contains a word index) and the word-break table the AVM uses to read word indexes (to process a query that contains the CONTAINS operator) must be identical. To ensure this, when you associate the compiled version of a word-break table with a database, the AVM writes cyclical redundancy check (CRC) values from the compiled word-break table into the database. When you connect to the database, the AVM compares the CRC values in the database to the CRC value in the compiled version of the word-break table. If they do not match, the AVM displays an error message and terminates the connection attempt.

If a connection attempt fails and you want to avoid rebuilding the indexes, you can try associating the database with the default word-break rules.

To rebuild the indexes, you can use the PROUTIL utility with the IDXBUILD or IDXFIX qualifier.

The basic syntax of PROUTIL with the IDXBUILD qualifier is:

The basic syntax of PROUTIL with the IDXFIX qualifier is:

Both the IDXBUILD or IDXFIX qualifiers have extensive options for selecting indexes and performance tuning. For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration.