Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

SQL Selector Workflow: Plan Control

The SQL Selector workflow allows you to choose original SQL from a batch of SQL statements.

To select original SQL using SQL Selector for Plan Control

  1. Select the SQL Details tab in the main window.
  2. Select Plan Control from the Optimize SQL start page.
  3. Enter SQL statements in the Alternative Details pane of the SQL Details tab.

  4. Click an icon to perform an operation.
  5. Select a connection.

  6. The SQL Selector window displays your SQL statements.

    The SQL list displays in the control grid on the left. When you select one of the SQL statements, the corresponding SQL text is highlighted in the right grid.

    The buttons on the user interface change accordingly if the selected SQL statement has a variable(s) or temp table(s). Review the following for additional information:

    If the SQL statement… the user interface displays…
    Does not contain a variable

    Click the OK button to use the selected SQL as the original SQL statement.

    Contains a variable(s)

    To enter bind variable values

    1. Click the Enter Bind Variables button.
    2. Click OKto use the selected SQL as the original SQL statement.

    Note: Click to return to the SQL list to select a different SQL as the original SQL statement.

    Contains a temp table(s)

    To create temp tables

    1. Click the Create Temp Tables button to create the relevant temp table(s).

      Note: If the SQL script for creating temp table(s) has variable(s), the Enter Bind Variables window displays.

    2. Click the OK button to use the selected SQL as the original SQL statement.

    Note: After you select the original SQL statement, the whole text is kept as the Batch Scope for a plan guide.

  

Related Documents