Chat now with support
Chat with Support

Welcome, Quadrotech customers to Quest Support Portal click here for for frequently asked questions regarding servicing your supported assets.

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Editor

The Editor tab of the Preferences window allows you to define the editable panes control and layout.

General

Use tab characters (Default = cleared)

Specify whether to use the tab character (ASCII 9) instead of spaces.

Smart tab (Default = checked)

Specify whether the tab aligns with the next non-whitespace character of the previous line.

Bracket pairing (Default = checked)

Specify whether to match the corresponding opening bracket when the ending bracket is typed.

Use lowercase for object name (Default = checked)

Specify whether to use lowercase for database object names or have them displayed in uppercase.

Block cursor for overwrite mode (Default = checked)

Specify whether to use the block cursor when in overwrite mode. Overwrite mode is when text entered at the cursor overwrites the existing text.

Show all characters (Default = cleared)

Specify whether to display all characters including spaces, carriage return and tabs on the screen.

Show gutter (Default = checked)

Specify whether to show a non-editable boarder on the left of the Editor pane.

Width (Default = 34, Range = 1 to 100 pixels)

Specify the gutter width in pixels.

Show line numbers in gutter (Default = checked)

Specify whether to show line numbers in the gutter.

Apply to SQL Worksheet only (Default = checked)

Specify to display the line number in the gutter only in the SQL Worksheet module when the Show line numbers in gutter option is selected. If not selected, the line numbers are displayed in all windows where you can enter and edit SQL text.

Show right margin ((Default = checked)

Specify whether to show a vertical line at the right margin.

Width (Default = 80, Range = 1 to 1000 characters)

Specify the width of the page or the right margin position.

Block indent size (Default = 3, Range = 1 to 20)

Specify the block indent size in characters.

Tab size (Default = 3, Range = 1 to 20)

Specify the character length of a tab.

Editing

Syntax highlight (Default = checked)

Specify whether to use syntax highlight. If selected, it is possible to define the format for the following syntax: reserved word, SQL function, comment, identifier, quoted identifier, string, number, symbol, data type, global variable, local variable, temporary table, system procedure, invalid object, force, difference highlight (for SQL Comparer), text selection, member lookup and argument lookup.

Auto correction (Default = checked)

Specify whether to automatically correct typing errors and abbreviations as characters are typed. Allows the addition, editing and deletion of the auto correction entries. Also allows the specification of the action key that triggers the automatic replacement.

Lookup

Member Lookup (Default = checked)

Specify whether to show the lookup hint for database object members. For example, displays a list column names when a table name or alias name is followed by a period.

Argument Lookup ((Default = checked)

Specify whether to show the argument parameters hint for database functions and procedures. These hints display when the opening bracket is typed.

Delay (Default = 0.75 sec, Range = 0.5 to 1.5 sec)

Specify the delay time before the lookup hint displays.

 

Related Topic

Related Documents