Sort Fields panel

You use the Sort Fields panel to sort multiple columns within the current object list.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                    Sort Fields                 Row 1 to 11 of 43

 Sort                                    Db2
 Column Asc/                    Column   Column
 Number Desc Column Name        Type     Number
             *                  *             *

 0      ASC  NAME               VARCHAR       1
 0      ASC  CREATOR            CHAR          2
 0      ASC  TYPE               CHAR          3
 0      ASC  DBNAME             CHAR          4
 0      ASC  TSNAME             CHAR          5
 0      ASC  DBID               SMALLINT      6
 0      ASC  OBID               SMALLINT      7
 0      ASC  COLCOUNT           SMALLINT      8
 0      ASC  EDPROC             CHAR          9
 0      ASC  VALPROC            CHAR         10
 0      ASC  CLUSTERTYPE        CHAR         11

 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel
Sort Column Number
The relative position of this column in the sort sequence. Specify 1 for the most significant column, 2 for the next significant, and so on.
Asc/Desc
Indicates if you want FM/Db2 to sort the column in ascending or descending sequence:
ASC
Ascending. To change from DESC, overtype with ASC or A.
DESC
Descending. To change from ASC, overtype with DESC or D.
Column Name
The name of the column as held in the Db2® catalog table.
Column Type
The data type of the column.
Db2® Column Number
The number of the column as held in the Db2® catalog table.

Parent panels

The Sort Fields panel is displayed when you enter SORT on the command line from any object list and the cursor is not positioned within any column.

Child panels

To display this panel… Use/do this
Databases panel Object Type 1
Table Spaces panel Object Type 2
Tables, Views and Aliases panel Object Type 3
Indexes panel Object Type 4
Columns panel Object Type 5
Synonyms panel Object Type 6
Application Plans panel Object Type 7
Application Packages panel Object Type 8
Collections panel Object Type 9
Database Request Modules panel Object Type 10
Schemas panel Object Type 11
Distinct Types panel Object Type 12
Functions panel Object Type 13
Stored Procedures panel Object Type 14
Triggers panel Object Type 15

Related tasks