SORT primary command

  • In View or Edit, the SORT primary command changes the order of the data you are browsing or editing in TABL display format.

    FM/Db2 sorts the data according to its hexadecimal representation using a hierarchy of keys, starting with the first specified column as the primary key, and subsequent specified columns as less significant keys. You specify the hierarchy left to right.

  • When you use the Object List utility (3.4) to display a list of objects, you can sort a column in the current object list by issuing the SORT primary command with the cursor positioned on the column you want to sort.

Syntax

Figure 1. Syntax (View or Edit)

1 SORT+   col_num
2.1! A
2.1 D
2.1 NX
2.1 X
Figure 2. Syntax (Object List utility)

1 SORT
col_num
The Db2® column number (specified as #n) of a column to be used as the sort key. You can specify between 1 and 5 column numbers. Multiple column numbers must be separated by a blank.
A
Sort data in ascending sequence. This is the default sequence.
D
Sort data in descending sequence.
NX
Non-excluded rows only. Sorts rows as if any excluded rows did not exist.
X
Excluded rows only. Sorts excluded rows as if any non-excluded rows did not exist.

Availability

Related tasks