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.