From the command line, start the Collate utility with this
command: COLLATE
The Collate Utility menu is displayed
Select option 3 - Database Upper Case Collate Sequence
Type the database name and press <Enter>. The Collate Options menu is displayed
Select option 1 - Alternate Sequence. The Collate Sequence table is displayed:
Use the cursor keys to move to the character whose position in the sequence you wish to modify. For example, to change the position of Ü, move the cursor to it
Press <Enter> to select the character. You are prompted to select a new position for the character
Move the cursor to the character's new position in the table
Press <Enter> and the Position in Collate Sequence menu is displayed. The Collate Sequence options are explained as follows:
| Option | Description |
|---|---|
| Same as preceding value |
Select this option to prevent DP4 from differentiating between the new character and the preceding character for collate purposes. For example, É is inserted after E in the collate table. If you select this option, É is treated the same as the character E for collate purposes |
| After preceding value |
Select this option to ensure that the new character is placed after the preceding character for collate purposes. For example, É is inserted after E in the collate table. If you select this option, É always appears after E for collate purposes. |
The character at the insertion point is moved one to the right, and the new character is inserted.
Press <Esc> to complete the changes. The collate sequence is stored in the database header.
Select option 8 - Exit to terminate the Collate utility.