Using the Product in a DB2 Environment › Analyze DB2 Data › Display a DECLARE Statement

Display a DECLARE Statement

1. Type SD in the LC field on the DB2 Statements panel and press Enter.

   The DECLARE Statement panel displays.

   The SD line command is valid for OPEN, FETCH, and CLOSE statements and UPDATE/DELETE statements that contain the clause WHERE CURRENT OF <cursor_name>.

   Customization for the Explain function must be completed.

    CA MAT ------------------- DECLARE Statement -------------- Row 1 to 9 of 9
    COMMAND ===>                                                SCROLL ===>  PAGE
   
            DBRM name: D91PROG                                   Profile: PROFT9
            Statement: 769                                      DB2 SSID: DIA3
            Timestamp: 09.035 12:46:13                           DB2 Rel: 9.1.0
   
    SQL Text
    ____________________________________________________________________________
    -----------------------------------------------------------------------------
   -
    DECLARE BT_D91PROG_CURSOR_FOR_TESTING_LONG_NAMES CURSOR FOR SELECT A .
    HEXROW , B . PACKROW , A . PRINTROW , B . NEGROW , A . CHARROW1 , B .
    CHARROW2 , A . CHARROW3 , B . CHARROW4 , A . CHARROW5 , B . CHARROW6 FROM
    DB2DATA A , DB2PART B WHERE A . PACKROW = B . PACKROW AND A . CHARROW4 = B
    . CHARROW4 AND A . CHARROW4 = 'BBBBB' AND B . CHARROW4 = 'BBBBB' UNION
    SELECT A . HEXROW , B . PACKROW , A . PRINTROW , B . NEGROW , A . CHARROW1
    , B . CHARROW2 , A . CHARROW3 , B . CHARROW4 , A . CHARROW5 , B . CHARROW6
    FROM DB2DATA A , DB2PART B WHERE A . PACKROW = B . PACKROW AND A . CHARROW4
    = B . CHARROW4 AND A . CHARROW4 = 'BBBBB' AND B . CHARROW4 = 'BBBBB'
   ******************************** End of Table ********************************
   

   This panel shows the DECLARE statement that is coded by the application programmer for this DB2 verb.