Use this panel to view or modify the full text of an SQL
statement for purposes of online tuning, or to create an SQL statement
to be explained.
This panel is displayed by pressing Enter in the SQL Text Entry
window, or by selecting the 1 field from the DB2® Explain Output panel. Figure 1. SQL Text Edit panel
ISREDDE2 XRK.PMO4.SPFTEMP1.CNTL Columns 00001 00072
****** ***************************** Top of Data ******************************
000001 SELECT COUNT ( * ) INTO :HV_LOC10_COUNT FROM DGO_SYSPACKAGE WHERE
000002 LOCATION = :HV_LOC10_LOCATION AND ( COLLID LIKE :HV_LOC10_COLLID OR
000003 COLLID LIKE :HV_LOC10_COLLID2 ) AND ( NAME LIKE :HV_LOC10_NAME OR NAME
000004 LIKE :HV_LOC10_NAME2 ) AND VERSION LIKE :HV_LOC10_VERSION QUERYNO
000005 001011010
****** **************************** Bottom of Data ****************************
Command ===> ________________________________________________ Scroll ===> CSR_
F1=Help F2=Split F3=Exit F5=Rfind F6=Rchange F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel F13=Help
F14=Split F15=End F16=Return F17=Rfind F18=Rchange F19=Up
F20=Down F21=Swap F22=Left F23=Right F24=Cretriev
From this panel, you can enter a new (or modify an existing) SQL
statement to assess the effect on access path selection. The statement
can be adjusted and then explained again to dynamically assess the
effect.
You can enter SQL text that exceeds the display depth by using
the scrolling keys F7 (Up) and F8
(Down).
To process and explain the entered SQL text, press F3
(Exit). The Db2 Explain Output
panel is displayed with a confirmation message.
To ignore the changes and return to the previous panel, press F12
(Cancel).