SQL Statement List panel (DBRMs)

The SQL Statement List panel shows a list of SQL statements for the selected DBRM. This window shows the statement number and the first 60 characters of the SQL statement text for each item listed. If many SQL statements are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list. Use the key F21 (Expand) to browse the SQL statement.

Figure 1. SQL Statement List panel

DGOMYWDQ                      SQL Statement List             Row 1 to 4 of 59

Local location . . . . . . . : PMODB2A           SDA2  V10
Current server . . . . . . . : PMODB2A           SDA2  V10

DBRM . . . . . . . . . . . . : DSNTIAUL                         +
Plan name  . . . . . . . . . : DSNTIAUL

S    Statement  SQL Statement Text
                ----+----1----+----2----+----3----+----4----+----5----+----6
_          724  DECLARE MSEL STATEMENT
_          935  WHENEVER SQLERROR GO TO EXECER11
_         8064  SELECT CURRENT SQLID INTO :CRNAME FROM SYSIBM . SYSDUMMY1
_         9162  ROLLBACK
******************************* Bottom of data ********************************


Command ===> ________________________________________________________________
 F1=Help      F2=Split     F3=Exit      F7=Up        F8=Down      F9=Swap
F12=Cancel   F16=Look     F17=Collect  F21=Expand   F22=Left     F23=Right

From this window, you can select an SQL statement to be explained. The SQL statement is then processed and the result is shown in the DB2® Explain Output panel.