IBM ISERIES SC41-5210-04 - Manual (Page 121)

SBCS character data in SBCS, DBCS-open, and DBCS-either fields are sorted in the order of the
hexadecimal representation of the characters or an order defined by a selected collating sequence. For
more information on collating sequences, see Chapter 9, “Selecting a collating sequence in Query for
iSeries”.
DBCS data in character fields is sorted by the hexadecimal representation of the data. The collating
sequence is not applied to DBCS data in DBCS character fields.
UCS2-graphic data is sorted by the hexidecimal representation of the data. The collating sequence is not
applied to UCS2-graphic data in UCS2-graphic fields.
Date, time, and timestamp fields are sorted in chronological order.
For all data types, null values are sorted last if the sort is in ascending order and are represented by a
dash (-). For example, for the following data:
field1 value
record
1 B
3 A
2 null value
4 null value
The sorted report looks like this:
A
B
-
-
Chapter 8. Selecting sort fields in Query for iSeries 109