To use the collating sequence from the mainframe server for sorting, set the COLLATINGSEQUENCE value::
COLLATINGSEQUENCE=1145
If CONNATINGSEQUENCE is set to 1145, the value will represent the EBCDIC code page to be use as the collating sequence when sorting data..
Default = 0 use ASCII collating sequence.
A summary of the limitations of this feature:
1) Only works with non-unicode data
2) Comparisons are done in codepage 1145 (which should be suitable for any EBCDIC platform)
3) There will be a small performance hit due to the extra translations.
Environments: Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = COLLATINGSEQUENCE
Unix Registry Setting: CONNX.COLLATINGSEQUENCE