Setting the Standard Collate Sequence

To reimplement the standard collate sequence for a database:

1. From the command line, start the Collate utility with this command:

   COLLATE

   The Collate Utility menu is displayed

2. Select option 2 - Database Upper Case Collate Sequence

3. Type the database name and press <Enter>. The Collate Options menu is displayed:

4. Select the Standard Sequence option

5. Select the Exit option

Alternatively you can simply enter collate -db dbname -standard at the command line.

If the database index is affected by the change, you are prompted to reorganise the database.