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:

Procedure

  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.
    Cmd
    Field where you specify the number for column position.
    Fix
    Displays fixed columns. Valid values are:
    • F–Indicates the column is fixed.
    • P–Indicates the column is permanently fixed.
    New
    Displays the new CORDER view settings.
    Old
    Displays the previous CORDER view settings.
    Column_Name
    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.