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

Models: DB2

1 132
Download 132 pages 16.76 Kb
Page 97
Image 97

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

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