Sort rows and columns

Using the SORT command, you can sort on single or multiple columns and specify sort order (ascending or descending) for each column in the sort.

Using the CSORT command, you can select one or more columns for sorting and thus modify the order of the rows that are displayed on many of the Db2 Table Editor product panels. Columns are selected by sort priority and direction. Direction is either ascending (default) or descending. When more than one column is selected for sorting, the second column only differentiates when rows have matching data in the first column. Similarly, a third column only impacts the sort when data in both the first two columns are identical. A maximum of nine columns can be selected for sorting at one time. Internal requirements may create a smaller maximum. A message is issued if the maximum number of columns selected for sorting is exceeded.