Installation
Installation Requirements
Install or Upgrade SQL Optimizer
Silent Install of SQL Optimizer
Uninstall SQL Optimizer
Register SQL Optimizer
Configuration
Troubleshoot SQL Optimizer
"Failed to Connect to IBM DB2 LUW"
No Index Recommendations from IBM DB2 LUW
"Failed to initialize the application"
Copyright
SQL Formatter Tutorial
The SQL Formatter formats SQL statements, verifies syntax, and color-codes variables, invalid field or table names, optimization forces and comments. The use of indenting and highlighting gives SQL statements a standard of formatting that is easy to read.
Formatting a SQL Statement
-
Click
.
-
After entering a SQL statement in the left pane of the window, click
.
-
The formatted SQL statement displays in the right pane of the window. Comments, bind variables, optimizer forces, invalid column or table names, and variables are highlighted in different colors. If there is a syntax error, an error message from DB2 LUW is displayed.