Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

SQL Formatter Window

The SQL Formatter window is divided into two sections:

Left Pane (Original SQL)

Provides an area for entering the SQL statement to be formatted.

Right Pane (Formatted SQL)

Displays the formatted SQL statement after the Format function is executed. Parameters, forces and comments are highlighted for ease of recognition. The color of the text is dependent on the syntax highlight definition set under the Editor tab in the Preferences.

 

Related Topics

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 image\B_SQLFormatter.gif.

  2. Enter the SQL text.

  3. Click image\B_Format.gif to format the SQL statement.

To help in the construction of SQL statements

Use these functions:

To terminate the format process

Click image\B_AbortFormat.gif.

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

 

Related Topics

Parameters within SQL Formatter

SQL statements can have parameters either prefixed with a "@" sign or without the "@". If parameters are recognized, they are highlighted in red (default color) after executing the Format function.

Note: If table names are in maroon (default color) it indicates that the table and corresponding columns are not recognized. Check that:

  • The login user has sufficient privilege to access the table.

  • You are connected to the correct database or set user.

  • Make sure you have the most up-to-date database information in memory. If not, execute the Synchronize Data Dictionary function from the Database menu.

 

Related Topics

SQL Formatter Functions

Below is a list of available functions available in the SQL Formatter window.

Button or Menu Function

SQL Menu

image\B_Format.gif image\B_AbortFormat.gif

Format/Abort Format

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopytoIndexAdvisor.gif

Send to Index Advisor

Edit Menu

image\B_CopyToSQLWorksheet.gif

Copy to SQL Worksheet

File Menu

Save SQL to SQL Repository

 

Syntax Highlight

 

Auto Correction

 

Bracket Pairing

 

Argument Lookup

 

Member Lookup

Edit Menu

image\B_Indent.gif

Indent

Edit Menu

image\B_Outdent.gif

Outdent

Edit Menu

image\B_Comment.gif

Comment

Edit Menu

image\B_Uncomment.gif

Uncomment

Edit Menu

image\B_Uppercase.gif

Uppercase

Edit Menu

image\B_Lowercase.gif

Lowercase

 

Related Topics

Related Documents