Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Editing the Explain report layout

Use this procedure to customize the layout of the Explain Object Selection List or the Explain Results panel.

  1. Put your cursor on the FILE task bar, and press Enter.A list of FILE options is displayed.

  2. Select Open Layout and press Enter.The Layout Data Set Panel is displayed in the Following Figure .

    PSSPLODS ----------------------- Layout Data Set ------------------------------
    Command ===>                                                                   
                                                                                  
    Layout Data Set 'RDADAC.SQLXPLR.CNTL(PSSREPA)'
                                                                                  
    Default Data Set 'BMCPERF.BMCSAMP(PSSREPA)'                                       
      (Used if layout data set is blank)                                           
                                                                                  
    Option   1. Edit layout data set                                               
             2. Browse layout data set                                             
             3. Use default data set instead of layout data set                    
             4. Overwrite layout data set with default data set and edit
  3. Type the name of the Layout Data Set used to control the appearance of the Explain report.

  4. In the Option field, specify Overwrite layout data set with default data set and edit and press Enter.The product replaces the contents of the layout data set with the contents of the default data set and opens the revised layout data set for editing in the Following Figure .

    File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help            
                                                                                  
    EDIT       RDADAC.SQLXPLR.CNTL(PSSREPA) - 01.31                  Columns 00001 00072
    Command ===>                                                  Scroll ===> CSR
    000086 [PACKAGE]                                                               
    000087 * THIS IS INFORMATION FROM SYSPACKAGE.                                  
    000088 *WIDTH SHOW      COL_NAME                       COLUMN HEADING          
    000089     16 S         COLLID                                                 
    000090      8 S         NAME                                                   
    000091      8 S         VERSION                        VERS                    
    000092      8 S         OWNER                                                  
    000093      1 S         VALID                                                  
    000094      1 S         OPERATIVE                      OPER                    
    000095      1 S         REOPTVAR                       REOPT                   
    000096      1 S         VALIDATE                                               
    000097      1 S         ISOLATION                                              
    000098      1 S         RELEASE                                                
    000099      1 S         EXPLAIN                                                
    000100      1 S         QUOTE                                                  
    000101      1 S         COMMA
  5. You can perform the following actions in the various sections of the layout data set. The changes you make here apply to the Explain Object Selection List or the Explain Results panel.

    • Specify a new value for the WIDTH of a column.

      If the display width of a field is too short to show all of the values in the field, one of the following events occurs:

      • For numbers, the product attempts to show the number up to the decimal point. If this is not possible, asterisks (*) are used to fill the entire field.
      • For characters, the product truncates the character text from the right.

      Note

      If the information is truncated, place your cursor on the field, and press F4 or F6 ( ZOOM). The contents of the entire field are displayed in a pop-up window.

    • Hide a column by typing H beside a COL_NAME in the SHOW column.

    • Display an existing column with a different name by specifying a new COLUMN HEADING.

      Note

      You cannot change the actual names of the columns.

    • Change the order in which the columns are displayed by moving a row within its section.
  6. Press F3 to save your changes.

Related topic

Explaining SQL Statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*