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