Skip to Content

Default language.

Information
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.

Explaining a package online

Use the following procedure to perform an online Explain on a package.

  1. Generate a list of packages to Explain.For instructions see Generating-a-list-of-packages-to-Explain. Be sure to specify List object(s) for the Processing Mode.
  2. Specify options for the Explain.For instructions see Specifying-Explain-options.

  3. On the Explain Object Selection List, specify the action that you want to perform on an object.

      FILE   COMMANDS   OPTIONS   HELP
    -------------------------------------------------------------------------------
    PSSPE100                    Explain Object Selection List                     
    Command ===>                                                  Scroll ===> CSR
                                                                      More:   - + >
        Actions: S H R RS RW RI XD XS XC XB XP                                         
    __ DEMOCJ           TRF1AFSV          RDAMCG2  Y     Y    N     B        S     
    __ DEMOCJ           TRF1BEFD          RDAMCG2  Y     Y    N     B        S     
    __ DEMOCJ           TRF1BEFI          RDAMCG2  Y     Y    N     B        S     
    __ DEMOCJ           TRF1BEFU          RDAMCG2  Y     Y    N     B        S     
    __ DEMOCJ           TRF1XX            RDAMCG2  Y     Y    N     B        S     
    __ DEMOCOLT         DEMOPKG1 V1.02    RDAJLG4  Y     Y    Y     R        S     
          STMTNO SQL-STATEMENT                                                     
    xd       228 DECLARE DEMOCUR1 CURSOR WITH HOLD FOR SELECT SN , PN , JN , QTY FR
                 DECLARE DEMOCUR1 CURSOR                                           
                 WITH    HOLD FOR                                                  
                 SELECT  SN, PN, JN, QTY                                           
                 FROM    IOD.SPJ                                                   
                 WHERE   SN = :WS-TEMP-01.WS-SN || 'ABCDS'                         
                   AND   PN = :WS-TEMP-01.WS-PN || 'ABCDE'                         
                   AND   JN = :WS-TEMP-01.WS-JN                                    
                 FOR                                                               
                 UPDATE  OF SN, PN, JN, QTY                                        
    __       241 DECLARE DEMOCUR2 CURSOR FOR SELECT FIRSTNME , MIDINIT , LASTNAME F

    1. To find a specific string of text, type FIND string on the COMMAND line, and press Enter. Press F5 to move the cursor to a subsequent instance of the specified text.

      Success

      Tip

      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.

    2. Specify the action that you want to perform and press Enter:

      To do this

      Perform this action

      Display severe, warning, and informational rules for the package, based on the bind information

      Type R in the space beside a package.

      Display the statements for the package

      Type S in the space beside a package.

      Display a formatted version of the statement text

      Type S in the space beside a statement.

      Display severe, warning, and informational rules for the statement, based on SQL syntax

      Type R in the space beside a statement.

      Perform a dynamic Explain on the statement

      Type XD in the space beside a statement.

      The Explain Results panel is displayed.

  4. Specify options on the Explain Results panel.For more information see Working-with-Explain-results.
  5. Review the results of your Explain.

Related topic

Explaining-SQL-Statements



 

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

MainView for DB2 6.1