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 |