Explaining a package online

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

1. Generate a list of packages to Explain.

   Be sure to specify List object(s) for the Processing Mode.

2. Specify options for the Explain.

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

   Explain Object Selection List - Dynamic Explain of a Statement

     FILE  COMMANDS  OPTIONS  HELP                                                
   -------------------------------------------------------------------------------
   PSSPE100                    Explain Object Selection List                      
   Command ===>                                                  Scroll ===> CSR  
                                                                    More:       >
      Actions: S H R RS RW RI XD XS XC XP XB                                      
      COLLID           NAME     VERS     OWNER    VALID OPER REOPT VALIDATE ISOLAT
      GXRV12PL         DOTSQL   PGMV1    RDAGXR   Y     Y    N     B        S     
         STMTNO SQL-STATEMENT                                                     
   XD        16 DECLARE C1 CURSOR FOR SELECT S . MNGEGRUPIDNT FROM TY4P . SDPDMNGE
      GXRV12PL         DOTSQL   PGMR_RDA RDAGXR   Y     Y    N     B        S     
   ******************************** Bottom of Data *******************************

   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.

      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.
      Perform a static Explain on the statement	Type XS in the space beside a statement. 1
      Perform an Explain Compare on a statement to compare a dynamic Explain to a static Explain	Type XC in the space beside a statement. 1
      Perform an Explain Package on the statement	Type XP in the space beside a statement. 1
      1. If you Explain a package, or if you Explain more than one statement at a time, the Explains are stacked. Type CAN to cancel the Explain.

      The Explain Results panel is displayed.

4. Specify options on the Explain Results panel.
5. Review the results of your Explain.