Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - 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

Bracket Pairing

Editor Functions > Bracket Pairing

Simple mistakes are often made during SQL construction because of uneven left and right brackets. With bracket pairing, the corresponding open bracket is matched with the closing bracket as you type the closing bracket.

To enable bracket pairing

  1. Click Preferencesimage\B_Preferences.gif

  2. Select the Editor tab.

  3. Under the General section, select Bracket Pairing.

Bracket pairing matches brackets for the parentheses ( ), the curly brackets { }, and the square brackets [ ].

 

Related Topic

Customize Editable Panes

Editor Functions > Customize Editable Panes

You can customize the behavior of editable panes in many ways. The editor options can be set in the Preferences window under the Editor tab. These options include:

 

Related Topic

Editor Functions

Editor Functions > Editor Functions

Below is a list of available functions within the editable panes.

Button or Menu

Function

 

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 Topic

Editor Panes Shortcuts

Editor Functions > Editor Panes Shortcuts

The following list is the quick reference to some common shortcut keys provided to quickly accomplish tasks that are performed frequently within the Editor panes.

Function

Shortcut Keys

Delete next word

CTRL+DELETE

Delete previous word

CTRL+BACKSPACE

Delete next character

DELETE

Delete previous character

BACKSPACE

Delete current line

CTRL+Y

Highlight a word

SHIFT+CTRL+LEFT or RIGHT ARROW

Highlight a character

SHIFT+LEFT or RIGHT ARROW

Cursor forward a word

CTRL+RIGHT ARROW

Cursor backward a word

CTRL+LEFT ARROW

Insert mode

INSERT

Bring up Member Lookup

CTRL+SPACEBAR

Bring up Argument Lookup

SHIFT+CTRL+SPACEBAR

Comment

SHIFT+CTRL+C

Uncomment

SHIFT+CTRL+N

Indent

SHIFT+CTRL+I

Outdent

SHIFT+CTRL+O

Uppercase

SHIFT+CTRL+U

Lowercase

SHIFT+CTRL+L

Quick Find

CTRL+Alt+F

Find

CTRL+F

Find Next

F3

Replace

CTRL+Alt+R

Go to Line

CTRL+Alt+G

Select All

CTRL A

Cut

CTRL X

Copy

CTRL C

Paste

CTRL V

Undo

CTRL Z

Save

CTRL S

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating