IBM SC41-5210-04 manual Query for iSeries Use V5R2

Table 3. Example of How a Code Table Works (continued). The value in the left column is the first half of the hexadecimal value. The value at the top of each column is the second half of the hexadecimal value. The lowercase a in this table is at ’81’X and the uppercase A is at ’C1’X. This is an example, a real table contains all the alphanumeric and special characters.

C

D

E

F

0 1 2 3 4 5 6 7 8 9 A B C D E F

A

When you use the hexadecimal collating sequence, the characters in a code table are ordered by ascending hexadecimal values. An advantage of hexadecimal collating is that it distinguishes between uppercase and lowercase letters.

For CCSID 37, the default for English language systems, the hexadecimal collating sequence is:

blank

miscellaneous characters, such as . + & % )

a through r

(tilde)

s through z

{

A through I

}

J through R

\

S through Z

0 through 9

To see what the hexadecimal collating sequence looks like, select option 3 (Define a collating sequence) on the Select Collating Sequence display and press the Enter key. The Define Collating Sequence display appears. Press F14 (hexadecimal sequence). Query for iSeries shows you the characters and their sequence numbers in the hexadecimal collating sequence.

Each character with a hexadecimal value in the range ’40’X to ’FE’X is listed. You can use the page keys to page through the list of characters. Press F11 to show the hexadecimal value of each character under the Hex column. Use F12 to return to the Select Collating Sequence display.

If hexadecimal collating is selected, the minimum and maximum values saved in summary-only output to a database file may differ from the corresponding values in a printed or displayed report, even though the same job CCSID is used to run the query. This happens only if values for a minimum or maximum field are converted to the job CCSID in order to be printed or displayed.

Using the language collating sequence for your country in Query for iSeries

You may want to select the collating sequence provided by Query for iSeries for your country so that character data is sorted in a more useful order for your language. In Great Britian and the United States, the collating sequence provided (in addition to hexadecimal) is Query for iSeries English. In this sequence,

114Query for iSeries Use V5R2