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.

Follow these steps:

1. Type S next to the DBRM/Package name in the LC (line command) column from the DB2 Statements panel.
2. 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 MAT obtains this SQL statement from DB2 space block (SPA).