IBM SC41-5210-04 manual Sorted report looks like this

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