SQL Optimizer for SAP ASE 3.9.1 - User Guide

SQL Worksheet Tab

SQL Worksheet

View SQL Worksheet page

The SQL Worksheet tab of the Preferences window allows users to determine if the commands are clear upon execution, the batch separator, the buffer size for the result set, and to specify how the results sets are displayed.

Execution

Clear commands upon execution (Default = checked)

Specify to clear the SQL statement or Transact-SQL code in the Editor pane after the command is successfully executed. If the execution is not successful, then the text remains in the Editor pane.

If this option in not selected, the text also remains in the Editor pane.

Note: After a successful execution, the text is always saved in the Command drop-down field at the top of the window.

Batch Separator (Default: GO)

Specify the separator used to signal the end of a batch of Transact-SQL statements.

Result buffer size

Unlimited or Fixed size (records)

Select Unlimited to return all records. Select Fixed size and then in the text field, set the maximum number of records to be returned. (Default fixed size: 1000)

Display results

Maximum characters per column: (Default: 256)

Specify how wide each column should be in the Resultn tab in the lower pane of the SQL Worksheet window.

Discard results: (Default: cleared)

Specify whether to show the results on the Resultn tab, or to just show the number of affected records on the Message Log tab.

Display results in

Grid or Text: Select between displaying the results in a grid or in plain text.

Under the Text option you can also select:

Output format (Default: Column aligned)

Select between Column aligned, Comma separated (CSV), Tab delimited, or Other delimiter.

Right aligned numerics: (Default: cleared)

When you select Column aligned for the Output format, specify whether or not to right align number columns.

Delimiter

When you select Other delimiter for the Output format, specify the character to be used as the delimiter between the columns.

Display headers:

Specify whether or not the column names are displayed.

Related Topic

SQL Workshop Overview

SQL Scanner Tab

SQL Scanner

The SQL Scanner settings are used to define the requirements for the SQL Scanner module.

SQL Scanner Options Settings

SQL Scanner Abstract Plan Settings

SQL Scanner General Settings

The settings in the SQL Classification tab are used by the SQL Scanner to help you identify which SQL statements are likely to be causing performance problems by classifying the SQL as Problematic, Complex, or Simple.

SQL Classification Settings

Related Topic

SQL Scanner Overview