Editing a long cell

You can view or edit the entire contents of a long cell with the Expand command.

About this task

If data in a cell is too long to appear on the screen, you can press PF11 to scroll the data within the value. If the data in the cell is XML data, <xml data> will appear instead of the cell contents. To view or edit the contents of the cell, use the Expand command.

Procedure

  1. In an open table, specify Expand on the Command line, and then move the cursor to the cell that you want to edit. Alternatively, you can place the cursor on the cell that you want to edit, and press PF4.
    Figure 1. Column Editor panel (ETI$EXPL)
    
 ETI$EXPL         Column Editor                            2016/09/08  19:26:39 
 Command ===> ________________________________________________ Scroll ===> PAGE 
                                                                                
 Creator . : USERID         >  Table . : TABLENAME                           >  
 Column  . : COLNAME        >  Type  . : DATATYPE                               
 Length  . : ________          Null  . . NO                                      
 Max . . . : ________          CAPS  . : OFF                                    
                                                                                
 ****** ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
 000001 COLUMN CONTENTS                                                         
 ***************************** Bottom of Data **********************************

    On the Column Editor panel (ETI$EXPL), you can specify the following commands:

    Command Description
    HEX ON Specify this command to edit data in hexadecimal format.
    HEX OFF Specify this command to return to normal edit mode.
    Note: The HEX ON and HEX OFF commands can be used on this panel (ETI$EXPL), and the setting is saved in your ISPF user-profile. You can also use the HEX command on the Edit Table Rows panel (ETI$EDIT) and the Form View panel (ETI$FORM) if your cursor is positioned in a cell of a table. In this case, the ETI$EXPL (Column Editor) panel will open with HEX mode already enabled.

    On this panel, the following fields are displayed:

    Field Description
    Table The name of the table in which the selected cell exists.
    Creator The creator of the table in which the selected cell exists.
    Column The name of the column in which the selected cell exists.
    Type The data type of the column in which the selected cell exists.
    Length The length in characters of the data in the selected cell.
    Max The maximum length in characters of the data in the selected cell.
    Null This value is NO if the selected cell does not have a value of null. The value is YES if the selected cell does have a value of null.
    CAPS Displays ON when caps mode is enabled, or OFF when it is not enabled.
  2. On this panel, view or edit the full content of cells that contain too much data to fit on the screen. You can also view additional information about the selected cell.
  3. When you are finished viewing or editing the data, press PF3.
    If you have made changes to the cell, Db2 Table Editor updates the cell with the information that you specified and returns to the Edit Table Rows (ETI$EDIT) panel.