Chat now with support
Chat with Support

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

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

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

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

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

Related Documents