サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for DB2 LUW 4.4.2 - Installation Guide

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

  1. Click image\B_SQLFormatter.gif.

  2. After entering a SQL statement in the left pane of the window, click image\B_Format.gif.

  3. 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.

 

Related Topics

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択