SQL Optimizer for DB2 LUW 5.0 - User Guide

Save SQL to SQL Repository

To save SQL statements to the SQL Repository module

1. Click .

2. Select the specific SQL to save and click the Save button.

3. Select the location in which to save the SQL statements.

Only valid SQL statements can be added to the SQL Repository.

Supported SQL Statements

The SQL Repository only supports a single SELECT, INSERT, UPDATE, or DELETE SQL statement. 

Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the Job Manager, the Scanned SQL Viewer, the SQL Repository, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory program (version 4.6 or later).

To create the text file to import into Benchmark Factory

1. Right-click and select Create Benchmark Factory Import File.

2. Select the specific SQL statements that you want to save. Click OK.

3. Enter the filename and select the file location. Click Save.

SQL Navigation

Several ways are provided to navigate through the SQL statements displayed in multiple tab sets.

• Click the tab set at the bottom of the window.

• Use the Navigate | Go to SQL function which navigates to a specify SQL number.

• Use the navigation buttons on the toolbar or corresponding menu items.

Find a SQL Using a Text String

The Find SQL function is available in the SQL Optimizer and Scanner SQL Viewer window. It searches through SQL statements until it finds the first occurrence of the text string you specify. In SQL Optimizer, Find SQL searches the SQL syntax currently displayed in the SQL Text pane. In SQL Scanner, the function searches across all SQL statements displayed on the SQL tabs.

To find specific text within the SQL statements

1. Select SQL | Find SQL.

2. Enter the text string to be found and click Find.

3. To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].