SQL Optimizer for SAP ASE 3.8 - Installation Guide

Format a SQL statement

The SQL Formatter checks the syntax of the SQL statement. The SQL statement is formatted only if the syntax is correct. The right pane [Formatted SQL] of the SQL Formatter window shows the formatted SQL statement. If the SQL statement has an invalid object, that object is highlighted in maroon (default color).

If you open the SQL Formatter with the SQL Optimizer as the active window, the SQL statement from the SQL Optimizer window is automatically copied to the SQL Formatter window. Otherwise, enter a SQL statement into the left pane of the SQL Formatter window.

To format a SQL statement

1. Click .

2. Enter the SQL text.

3. Click to format the SQL statement.

To help in the construction of SQL statements

Use these functions:

• Auto Correction
• Member and Argument Lookup
• Indent
• Outdent
• Uppercase
• Lowercase
• Comment
• Uncomment

To terminate the format process

Click .

Note: The SQL Format supports only a single SELECT, SELECT INTO, DELETE, UPDATE, and INSERT SQL statement.

Related Topics

SQL Formatter Overview

SQL Formatter Window

Parameters within SQL Formatter

SQL Formatter Functions