Defining sort columns

You can select a maximum of nine columns for sorting at one time. Internal requirements may create a smaller maximum. You see a message if the maximum number of columns selected for sorting is exceeded.

About this task

Note: CSORT and SORT are synonymous.

To invoke sorting:

Procedure

  1. Type CSORT (or SORT) in the option line on any display panel and press Enter. The Define Sort Columns panel displays:
    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 or not the view you define is permanent or temporary. Valid values are:
    • Y – View of customizations is permanent.
    • N – View of customizations is temporary.
    Reset View
    Resets all customizations.
    Stop Sorting
    Indicates whether or not 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 – Values are listed in ascending order, smallest to largest (default).
    • 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.