Candle-lite DB2 manual SQL Text ATF. You can access the SQL Text panel through

Using the OMEGAMON II for DB2 Callable Interface

Values for the SQL Process Level are described in the following table.

Fields for Terminal		Description
Options
SQL Process Level	Type of processing to use for SQL text when pressing the SQL Process
	function key.
	You can process SQL from the following panels:
	■	SQL Call being Executed (Thread Detail). See “EXPLAINing SQL
		Code” on page 61.
	■	SQL Text (ATF). You can access the SQL Text panel through the
		Application Trace Facility. Select the SQL TEXT pushbutton from the
		Application Trace SQL Detail screen.
	■	Thread History Dynamic SQL Detail
SQL Process PF Key	If you have set up !DB/EXPLAIN for direct access, pressing this function
	key directly invokes !DB/EXPLAIN. Otherwise, it invokes the SQL copy
	and paste facility to perform the EXPLAIN.
CUA/TSO Toggle key	Use to toggle between CUA and TSO sessions.

The following table provides a list of fields and valid values for completing the SQL Process Level field on the Terminal Options panel.

Values for SQL	Description
Process Level
MANUAL	After you have selected the SQL text to be EXPLAINed, you must use the
	function key defined (SQL Process key) to copy the SQL. Then, switch to
	TSO/ISPF (CUA/TSO toggle), and paste the SQL, again using the
	function key you defined.
	Note: To use MANUAL or AUTO, a TSO/ISPF edit session must be
	active in the background.
AUTO	After selecting SQL text, use the SQL Process key to copy and
	automatically insert the text into the member currently in use in the
	TSO/ISPF edit session. The placement of SQL text depends on the cursor
	position within the TSO/ISPF session.
	Note: To use MANUAL or AUTO, a TSO/ISPF edit session must be
	active in the background.
SAVE	After selecting the SQL text, use the SQL Process key to copy and
	automatically save the SQL text to the partitioned dataset member
	defined on the Save SQL Text Parameters panel. Text will either overwrite
	the existing contents of the member or be appended to it, depending on
	the type of save defined on this panel. This option does not require a
	TSO/ISPF edit session.
EXPLAIN	This option invokes !DB/EXPLAIN, which produces a variety of
	!DB/EXPLAIN reports. Use the pushbuttons to view the various report
	sections. Complete the required options for the EXPLAIN option on the
	!DB/EXPLAIN panel.

Using OMEGAMON II for DB2 with !DB/EXPLAIN 97