SQL Statement Selection panel

Use the SQL Statement Selection panel to view a summarized list of the valid SQL statements within the specified source area. If there are many SQL statements listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list.

Figure 1. SQL Statement Selection Panel

DGOMYWSS                SQL Statement Selection                Row 1 to 2 of 2

This panel summarizes the SQL statements found in the following source
module that can be explained.

Source . . : PMDEV51.COMM.COBSRCE(PGMEXP01)

Select an SQL statement, then press Enter

S   Line No  SQL Statement Text
_        80  DECLARE CUR1 CURSOR WITH HOLD FOR S
/       110  SELECT C1,C2,C3,C4,C5,C6 INTO :DCLTAB1 FROM TAB1 WHERE C1 =
--- End of List ---


Command ===> ____________________________________________________________
 F1=Help    F2=Split   F3=Exit    F7=Up      F8=Down    F9=Swap   F12=Cancel

You can select any SQL statement that is listed on the SQL Statement Selection panel for Explain processing by typing a slash (/) next to the line to be explained as shown in the figure above. The SQL statement is then processed even if the SQL statement text exceeds the specified range. Then the Online Monitor is accessed. With the Online Monitor, you can view the Explain output on the DB2® Explain Output panel. For more information, see Explain output (Db2 Explain Output panel).

From the SQL Statement Selection panel, you can access the Source Explain Options window by using the OPTIONS command. In the Source Explain Options window, you can change the Source Explain processing options.