SQL Optimizer for DB2 LUW 4.3.1 - User Guide

Open SQL from SQL Repository

SQL statements saved in the SQL Repository can be copied to the editable pane in other modules.

To copy SQL from the SQL Repository

1. From an editable pane in a module other than the SQL Repository, select File | Open SQL from SQL Repository.

2. Navigate through the tree structure and select the SQL statement.

3. Click Open.

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.