Sorting the data

To sort the data you are viewing or editing in TABL display format, use the SORT primary command.

You can specify up to 5 column numbers (the most significant first) and whether you want the data sorted in ascending (the default sequence) or descending sequence for each column number you specify.

Examples

SORT #7 D #6 #3
Sorts all rows on the column with column number #7 (primary sort key) in descending order, then on the column with column number #6 (secondary sort key) in ascending order, then on the column with column number #3 (minor sort key) in ascending order,
SORT #6 X
Sorts all excluded rows on the column with column number #6 in ascending order (as if non-excluded rows did not exist).
Note: The SORT command only changes the order in which you view the data; it has no effect on the order in which the data is stored within Db2®.

Related references