Chat now with support
Chat with Support

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

Change Text to Uppercase and Lowercase

Editor Functions > Change Text to Uppercase and Lowercase

Text can be changed from uppercase and lowercase by selecting the text and using the Uppercase and Lowercase functions.

To change text to uppercase

Select the text and click Uppercaseimage\B_Uppercase.gif.

To change text to lowercase

Select the text and click Lowercaseimage\B_Lowercase.gif.


Related Topic

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



Syntax Highlight


Auto Correction


Bracket Pairing


Argument Lookup


Member Lookup

Edit Menu



Edit Menu



Edit Menu



Edit Menu



Edit Menu



Edit Menu




Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating