Adjusting the Sort Sequence for IBM i (Magic xpa 3.x)
IBM i uses the EBCDIC character set instead of the ANSI character set used on the PC.
In the ANSI character set, table numbers come before characters: ‘1’<‘A’.
In the EBCDIC character set, characters come before table numbers: ‘1’>’A’. Therefore, when you use Magic xpa for IBM i with key fields that contain numbers and characters, you will not be able to perform range and locate operations. For example, From: ‘112323’ TO ‘A43434’ will end with No results.
To adjust the Sort sequence for IBM i, each language should have its own Alternate Collating Sequence (ACS) file defined in the AS400 DBMS properties and the DB2/400 DBMS properties, depending on the gateway used.
-
In the DBMS repository, click Alt+Enter from the AS400 or the DB2/400 entry, or both, depending on the gateway you are defining, to open the DBMS Properties dialog box.
-
Specify ACS400.XXX, where XXX is a shortcut for the language name, such as ACS400.ENG or ACS400.GER for the ACS file.
|
Note:
|
To avoid unexpected results with Range and Locate operations, you must define the ACS=ACS400.XXX keyword in the Alternate Collating Sequence file.
|
