CA 2E lets you specify a keyword to direct the i OS program to use an alternative collating sequence table when sequencing the records.
A typical example is to use the i OS-supplied translate table, QCASE256, to make the collating sequence for both upper and lower case the same. This creates an access path that suppresses unwanted upper/lower case discrepancies in the collating sequence while preserving the upper/lower case differences in the data. Any field used as a key for this access path should be similarly translated (uppercase only).
Specify Alternate Collating Sequence. At the Edit Access Path Details panel, enter or change the keyword name of the alternative collating sequence table in the Alternating Collating Table field and press Enter.
Use the i OS Create Table (CRTTBL) command to create the table or use an existing i OS table, such as QSYSTRNTBL or QCASE256.
|
Copyright © 2014 CA.
All rights reserved.
|
|