Defining sort columns

You can sort display data by columns. You can select up to nine columns for sorting.

About this task

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.

Note: CSORT and SORT are synonymous.

Procedure

  1. Type CSORT (or SORT) in the option line on any display panel and press Enter.
    The Define Sort Columns panel displays as shown in the following figure:
    Figure 1. Define Sort Columns panel
     SORT  -------------------- Define Sort Columns ------------ YYYY/MM/DD HH:MM:SS
 Option  ===>                                                   Scroll ===> PAGE
 ------------------------------------------------------------------------      >
                                                                     ROW 1 OF 9 
                                                                                
 Column Function ===> 4 (1-Fix/Unfix, 2-Order, 3-Size, 4-Sort)                  
 Permanent View  ===> N (Y-Perm, N-Temp)  Reset View ===> N (Y,N)               
 Stop Sorting    ===> N (Y,N)                                                   
                                                                                
                                                                                
 Cmd Dir New Old Column_Name                                                    
                 CMD                                                            
 _   _           NAME                                                           
 _   _           CREATOR                                                        
 _   _           UPDT                                                           
 _   _           DESCRIPTION                                                    
 _   _           LAST_USER                                                      
 _   _           LAST_UPDATED                                                   
 _   _           CRTD_USER                                                      
 _   _           CREATED_USER                                                   
                                                                                
 Enter: Process selections; PF3: Exit and save; CAN: Exit without save          
 Ord: 1-9 Dir: A Asc D Desc

    The following fields appear on the Define Sort Columns panel:

    Column Function
    Enables you to jump to any of the CSET functions by typing in the appropriate number. The number corresponding to the current option displays in this field.
    Permanent View
    Indicate whether the view you define is permanent or temporary. Valid values are:
    • Y–View customizations are permanent.
    • N–View customizations are temporary.
    Stop Sorting
    Indicates whether to stop sorting as specified. Valid values are:
    • Y–Stop sorting.
    • N–Continue sorting.
    Cmd
    Field where you specify the sort order.
    Dir
    Specifies the lexicographic order for the column. Valid values are:
    • A–(Default) Values are listed in ascending order, smallest to largest.
    • D–Values are listed in descending order, largest to smallest.
    New
    Displays the new CSORT view settings.
    Old
    Displays the previous CSORT view settings.
    Column_Name
    Shows the name of the column.
  2. Type A or D in the Cmd field next to the columns on which you want to base your sort.
  3. Press Enter. The new sort preferences are displayed in the New column.
  4. Press PF3 to return to the display panel.