SQL Statement List panel (Packages)

The SQL Statement List panel shows a list of SQL statements for the selected package. For each item listed, the statement number and the first 60 characters of the SQL statement text are shown. 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

DGOMYWKQ                      SQL Statement List               Row 1 to 7 of 7

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

Collection . . . . . . . . . : KO2EX510                         +
Package  . . . . . . . . . . : DGO@TPG1                         +
Version  . . . . . . . . . . : O510_PM32647C                    +

S    Statement  SQL Statement Text
                ----+----1----+----2----+----3----+----4----+----5----+----6
_           36  DECLARE DGO_SYSPACKAGE TABLE ( LOCATION VARCHAR ( 128 ) NOT
_      1011001  SELECT LOCATION , COLLID , NAME , CONTOKEN , OWNER , CREATOR
_      1011002  SELECT LOCATION , COLLID , NAME , CONTOKEN , OWNER , CREATOR
_      1011003  SELECT DEGREE INTO :HV_SYSPACKAGE_DEGREE FROM DGO_SYSPACKAGE
_      1011051  SELECT LOCATION , COLLID , NAME , CONTOKEN , OWNER , CREATOR
_      1011052  SELECT LOCATION , COLLID , NAME , CONTOKEN , OWNER , CREATOR
_      1011053  SELECT DEGREE INTO :HV_SYSPACKAGE_DEGREE FROM DGO_SYSPACKAGE
******************************* 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 the SQL statement to be explained. The SQL statement is then processed and the result is shown in the DB2® Explain Output panel.