Sort Sequence
Specifies which sort sequence should be used for this transfer
request.
- iSeries job default
- Sort by the table identified on the iSeries, eServer™ i5, or System i5® as the job sort table.
- Hexadecimal
- Sort by the internal hexadecimal representation.
- User specified table
- Sort by the table identified by the user in a subsequent prompt.
- Shared Weight Table
- Sort by the shared weight table associated with the language named in a subsequent prompt.
- Unique Weight Table
- Sort by the shared unique table associated with the language named in a subsequent prompt.
Changing the sort sequence affects the order in which records appear only if the ORDER BY clause is being used. The sort sequence affects all character comparisons that depend on the order of the alphabet. Such comparisons can occur in the WHERE clause, the GROUP BY clause, the HAVING clause, the JOIN BY clause, the IN predicate, the LIKE predicate, the BETWEEN predicate, the MAX function, and the MIN function. Comparison operations are =, <>, >, >=, and >=.