Using the Product in a DB2 Environment › Analyze DB2 Data › Display the SQL Statements from the DB2 Statements Panel

Display the SQL Statements from the DB2 Statements Panel

You can display the SQL statement belonging to a DBRM/Package name that is listed on the DB2 Statements panel.

1. From the DB2 Statements panel, type S next to the desired DBRM/Package name in the LC (line command) column, and press Enter.

   The SQL Statements panel displays.

    CA MAT ---------------------- SQL Statements ------------- Row 1 to 3 of 3
    COMMAND ===>                                                  SCROLL ===> HALF
   
        DBRM name: STPROC91                                     Profile: PROFT9
        Statement: 97                                          DB2 SSID: DIA3
        Stmt type: SELECT                                       DB2 Rel: 9.1.0
        Timestamp: 08.030 15:12:33                               Source: CATALOG
                                                                  Block: DB2
        Line commands: E - Explain  I - Explain Information
                       
    LC SQL Text
       ____________________________________________________________________________
    -------------------------------------------------------------------------------
    __ SELECT HEXROW , PACKROW , PRINTROW , NEGROW , CHARROW1 , CHARROW2 ,
       CHARROW3 , CHARROW4 , CHARROW5 , CHARROW6 INTO : H , : H , : H , : H , : H
       , : H , : H , : H , : H , : H FROM DB2DATA WHERE HEXROW = 1000000
    ********************************* End of Table ********************************
   
   

   This panel displays the SQL text for the statement. Extra spaces have been removed from the statement text. CA Mainframe Application Tuner obtains this SQL statement from DB2 space block (SPA).