Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

SQL Worksheet

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.


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.


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

Related Documents