as in most Query for iSeries language sequences, each pair of uppercase and lowercase letters (such as
A
and
a
) sort together because they share a collating weight that is distinct from the weights of other
letters.
The language collating sequence is not saved in the query definition. If you save your query and it is used
on a system with a different language, the collating sequence for the other language is used. When you
need to save the language used for collating, use option 3 (Define the sequence) on the Select Collating
Sequence display and press F15.
Defining your own collating sequence in Query for iSeries
You may want to define your own collating sequence so that character data is sorted according to your
particular needs.
For example, you have a two-digit customer account number field that has gone beyond its maximum of
99
, and entries in this field after
99
are alphabetic—
A1
,
A2
, and so on. You want the alphabetic entries
sorted to follow the numeral entries. You can define your own collating sequence so that the alphabetic
data follows the numeric data for this particular query.
To define your own collating sequence, type a 3 in the
Collating sequence option
prompt on the Select
Collating Sequence display and press the Enter key.
Select Collating Sequence
The selected collating sequence will be used for character fields when
sorting, selecting records, joining files, finding minimum and maximum
values, and determining when a control break has occurred.
Type choices, press Enter.
Collating sequence
option . . . . . . . .
3
1=Hexadecimal
2=Query for iSeries English
3=Define the sequence
4=Translation table
5=Systemsort sequence
The Define Collating Sequence display is the next display you see.
Define Collating Sequence
CCSID. . . . . . . . . . . . . . :
37
Position to . . . . . . . . . . . _
Char
Type sequence number (0-9999) for each character, press Enter.
(Use the same sequence number to have characters collate in a group.)
Sequence Char Hex
Sequence Char Hex
Sequence Char Hex
10
40
90
c
83
140
h
88
20
41
90
C
C3
140
H
C8
30
E1
100
d
84
150
i
89
40
-
60
100
D
C4
150
I
C9
50
’
7D
110
e
85
160
J
D1
60
-
CA
110
E
C5
160
j
91
70
a
81
120
f
86
170
K
D2
70
A
C1
120
F
C6
170
k
92
80
b
82
130
g
87
180
L
D3
80
B
C2
130
G
C7
180
l
93
More...
F3=Exit
F11=Chars only
F12=Cancel
F14=Hexadecimal
F15=Language sequence
F16=Use default
F20=Renumber
F24=More keys
Collating sequence initialized fromnational language sequence
Chapter 9. Selecting a collating sequence in Query for iSeries
115
Summary of Contents for @server iSeries
Page 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 2: ......
Page 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 12: ...x Query for iSeries Use V5R2 ...
Page 14: ...2 Query for iSeries Use V5R2 ...
Page 32: ...20 Query for iSeries Use V5R2 ...
Page 38: ...26 Query for iSeries Use V5R2 ...
Page 44: ...32 Query for iSeries Use V5R2 ...
Page 116: ...104 Query for iSeries Use V5R2 ...
Page 122: ...110 Query for iSeries Use V5R2 ...
Page 146: ...134 Query for iSeries Use V5R2 ...
Page 150: ...138 Query for iSeries Use V5R2 ...
Page 174: ...162 Query for iSeries Use V5R2 ...
Page 178: ...166 Query for iSeries Use V5R2 ...
Page 196: ...184 Query for iSeries Use V5R2 ...
Page 198: ...186 Query for iSeries Use V5R2 ...
Page 204: ...192 Query for iSeries Use V5R2 ...
Page 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Page 206: ...194 Query for iSeries Use V5R2 ...
Page 210: ...198 Query for iSeries Use V5R2 ...
Page 242: ...230 Query for iSeries Use V5R2 ...
Page 256: ...244 Query for iSeries Use V5R2 ...
Page 270: ...258 Query for iSeries Use V5R2 ...
Page 272: ...260 Query for iSeries Use V5R2 ...
Page 292: ...280 Query for iSeries Use V5R2 ...
Page 293: ......
Page 294: ... Printed in U S A SC41 5210 04 ...