Resizing columns

The CSIZE option enables you to change the displayed width of columns.

About this task

This function is primarily intended for non-numeric data where there are large blank areas in all (or most) rows in a given column. Although the displayed width may change, the underlying data does not change.

If a column's size is less than the column maximum, it is possible that some date is not displayed. INNER COLUMN SCROLLING and CEXPAND can be used to see data outside the display range of the resized column.

Note: If the minimum and maximum column widths are equal, the column cannot be resized.

To resize columns:

Procedure

  1. Type CSIZE in the option line on any display panel and press Enter.
    The Define Column Size panel displays as shown in the following figure:
    Figure 1. Define Column Size panel
     CSIZE -------------------- Define Column Size ------------- YYYY/MM/DD HH:MM:SS
     Option  ===>                                                   Scroll ===> PAGE
     --------------------------------------------------------------------------   +>
                                                                         ROW 1 OF 9 
                                                                                    
     Column Function ===> 3 (1-Fix/Unfix, 2-Order, 3-Size, 4-Sort)                  
     Permanent View  ===> N (Y-Perm, N-Temp)  Reset View ===> N (Y,N)               
                                                                                    
     Device_Width   :  80                                                           
     Old_Fixed_Width:  37       Old_Unfixed_Width:  43                              
     New_Fixed_Width:           New_Unfixed_Width:                                  
     -------------------------------------------------------------------------------
                                                                                    
     Cmd New Old Min Max Fix Column_Name                                            
           5   5   5   5 P   CMD                                                    
          32  32  32  32 P   NAME                                                   
          10  10  10  10     CREATOR                                                
           5   5   5   5     UPDT                                                   
          32  32  32  32     DESCRIPTION                                            
          10  10  10  10     LAST_USER                                              
                                                                                    
     Enter: Process selections; PF3: Exit and save; CAN: Exit without save          
     Line Cmds: Column size, between MIN and MAX                                    

    The following fields appear on the Define Column Size 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.
    Reset View
    Resets all customizations.
    Device_Width
    Shows the current display device size (screen width).
    Old_Fixed_Width
    Shows the sum of the FIXED column widths.
    Old_Unfixed_Width
    Shows the UNFIXED area.
    New_Fixed_Width
    Shows the sum of the FIXED column widths.
    New_Unfixed_Width
    Shows the UNFIXED area.
    Cmd
    Field where you specify the number for column position.
    New
    Displays the new CSIZE view settings.
    Old
    Displays the previous CSIZE view settings.
    Min
    Displays the minimum column length.
    Note: If the minimum and maximum column widths are equal, the column cannot be resized.
    Max
    Displays the maximum column length.
    Note: If the minimum and maximum column widths are equal, the column cannot be resized.
    Fix
    Displays fixed columns. Valid values are:
    • F–Indicates the column is fixed.
    • P–Indicates the column is permanently fixed.
    Column_Name
    Shows the name of the column.
  2. Type the desired column size in the Cmd field next to the column you want to resize.
    Note: The column size you specify must be between the Min and Max values shown for that column.
  3. Press Enter.
    The new view criteria display in the New column.
  4. Press PF3 to return to the display panel.