SQL Optimizer for SAP ASE 3.9 - User 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.

To format a SQL statement

1. Click .

2. After entering a SQL statement in the left pane of the window, click .

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 Adaptive Server displays.

Related Topic

SQL Formatter Overview

User-Defined Temp Tables Tutorial

When your SQL statement uses a temporary table, you must create a temporary table before you use the SQL statement in several modules. When you exit from the program or connect to another session, all the temporary tables you created are dropped.

Create Temporary Tables 

1. Click .

2. On the Creation tab, type in the statements for creating the temp table. You may include CREATE, SELECT INTO, INSERT, UPDATE and DELETE statements.

3. Click Execute.

Related Topic

User-Defined Temp Tables Overview

SQL History Tutorial

Throughout the use of the product, SQL statements are saved in the SQL History so that you can use them again. They are stored in a file so that they are available even if you exit the program.

Find Previously Used SQL Statements

1. Click .

2. To lookup SQL statements, enter the text string to search for in the SQL Text field. You can specify if you want to search in the last connection or last action. In the Last Action field, select an action from the drop down field. Only actions that have occurred in the present session will be available.

3. Select the SQL statement and click one of the buttons in the window to copy the SQL statement to another module.

Related Topic

SQL History Overview

Preferences