Resizing columns

The CSIZE command enables you to change the displayed width of columns. 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 might change, the underlying data does not change.

About this task

If a column's size is less than the column maximum, some date might not be displayed. You can use the INNER COLUMN SCROLLING and CEXPAND commands to view data outside the display range of the resized column.

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

Procedure

  1. Specify CSIZE on the Option line on any display panel and press Enter.
    Figure 1. Define Column Size panel (BSYSIZ)
     BSYSIZ ------------- Define Column Size -------------- 2021/11/11 11:57:46
     Option  ===>                                              Scroll ===> PAGE
     Commands: Enter: Process selections;                                           
     Cmd: Column size, between MIN and MAX                                          
     --------------------------------------------------------------------------     
                                                                     ROW 1 OF 6 
                                                                                    
     Column Function ===> 3 (1-Fix/Unfix, 2-Order, 3-Size, 4-Sort)                  
     Permanent View  ===> Y (Y-Perm, N-Temp)  Reset View ===> N (Y,N)               
                                                                                    
     Device_Width   :  80                                                           
     Old_Fixed_Width:   5       Old_Unfixed_Width:  75                              
     New_Fixed_Width:           New_Unfixed_Width:                                  
     --------------------------------------------------------------------------
                                                                                    
     Cmd New Old Min Max Fix Column_Name                                            
           5   5   5   5 P   CMD                                                    
               9   2   9     SOURCE_VOLUMES                                         
               8   2   8     SOURCE_DEVTYPE                                         
               6   2   6     SOURCE_UNIT                                            
              10   2  10     TARGET_VOLUMES                                         
              42  10  42     MESSAGE_AREA                                           
    On the Define Column Size panel, the following fields are displayed:
    Column Function
    Specify the appropriate number to jump to any of the CSET functions. The number corresponding to the current option displays in this field.
    Permanent View
    Specify whether the view you define is permanent or temporary. Valid values are: Y (view customizations are permanent) or N (view customizations are temporary).
    Reset View
    Resets all customizations.
    Device_Width
    Displays the current display device size (screen width).
    Old_Fixed_Width
    Displays the sum of the FIXED column widths.
    Old_Unfixed_Width
    Displays the UNFIXED area.
    New_Fixed_Width
    Displays the sum of the FIXED column widths.
    New_Unfixed_Width
    Displays the UNFIXED area.
    Cmd
    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 that the column is fixed) or P (indicates that the column is permanently fixed).
    Column_Name
    Displays the name of the column.
  2. Specify the 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 that are displayed for that column.
  3. Press Enter.
    The new view criteria is displayed in the New column.
  4. Press PF3 to return to the display panel.