Repositioning columns

The CORDER option enables you to reposition report columns. If any columns are fixed, they are grouped together as the leftmost report columns. The unfixed columns are grouped together to the right of any fixed columns.

About this task

CORDER does not move a column out of its group. A fixed column cannot be relocated to the right of an unfixed column. Likewise, an unfixed column cannot be relocated to the left of a fixed column.

To reposition columns:


  1. Type CORDER in the option line on any display panel and press Enter.
    The Define Column Display Order panel displays as shown in the following figure:
    Figure 1. Define Column Display Order panel
     CTCORD ----------------- Define Column Display Order -----  YYYY/MM/DD HH:MM:SS
     Option  ===>                                                   Scroll ===> PAGE
     ------------------------------------------------------------------------      >
                                                                         ROW 1 OF 9 
     Column Function ===> 2 (1-Fix/Unfix, 2-Order, 3-Size, 4-Sort)                  
     Permanent View  ===> N (Y-Perm, N-Temp)  Reset View ===> N (Y,N)               
     Cmd Fix New Old Column_Name                                                    
     ___ P         1 CMD                                                            
     ___ P         2 NAME                                                           
     ___           3 CREATOR                                                        
     ___           4 UPDT                                                           
     ___           5 DESCRIPTION                                                    
     ___           6 LAST_USER                                                      
     ___           7 LAST_UPDATED                                                   
     ___           8 CRTD_USER                                                      
     ___           9 CREATED_USER                                                   
     ***************************** Bottom of Data **********************************
     Enter: Process selections; PF3: Exit and save; CAN: Exit without save          
     Line Cmds: Specify number for column position                                  

    The following fields appear on the Define Column Display Order 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
    Indicates whether the view you define is permanent or temporary. Valid values are:
    • Y–View customizations are permanent.
    • N–View customizations are temporary.
    Reset View
    Resets all customizations.
    Field where you specify the number for column position.
    Displays fixed columns. Valid values are:
    • F–Indicates the column is fixed.
    • P–Indicates the column is permanently fixed.
    Displays the new CORDER view settings.
    Displays the previous CORDER view settings.
    Shows the name of the column.
  2. Type a number next to a column to specify its order.
  3. Press Enter.
    The new column order numbers display in the New column next to each column.
  4. Press PF3 to return to the display panel.