SQL Optimizer for DB2 ZOS 5.6 - Release Notes

Set Bind Variables

You need to define the values of SQL statement variables before you optimize the statement. The Set Bind Variables window displays automatically when you use SQL Optimizer for a statement with variables.

Troubleshooting: If the Set Bind Variables window displays when you optimize a statement without variables, make sure you spelled the column and table names correctly, you selected the correct database or user, and you selected a table or column that exists in the database.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set a bind variable

1. Select the SQL Details tab in the main window.

2. Enter a SQL statement with a bind variable.

   Note: SQL Optimizer currently supports the following bind variables data type:

   • CHAR

   • NUMERIC
   • DECIMAL
   • INTEGER
   • SMALLINT
   • FLOAT
   • REAL
   • DOUBLE
   • DATETIME
   • VARCHAR
   • TYPE_DATE
   • TYPE_TIME
   • TYPE_TIMESTAMP
   • GRAPHIC
   • VARGRAPHIC
   • LONGVARGRAPHIC
   • BLOB
   • CLOB
   • DBCLOB
   • DATALINK

3. Click .

4. Review the following for additional information:

   Bind Variables List	Description
   Datatype	Click and select the variable datatype.
   Null	Select the checkbox if the value for the variable is null.
   Variable Value	Enter a value for the variable.
   Browse Data	Description
   SELECT	Click and select column references for the variables. Note: SQL Optimizer selects the All Columns checkbox by default.
   FROM	Click and select table references for the variables. Tip: Click to browse to tables in a different database.
   WHERE	Enter a WHERE clause or click to select a previously entered clause.
   ORDER BY	Enter a ORDER BY clause or click to select a previously entered clause.

Related Topics

Optimize SQL Statements

Test Run SQL Alternatives