Chat now with support
Chat mit 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

Find

SQL Information and Functions > Search Menu > Find

The Find search function brings up the Find Text window where you can select the search criteria.

To search with Find

Select Search | Find [Ctrl + F]

The search is refined using the following settings:

Options

  • Case sensitive
  • Searches for the text in exact case that you enter it.
  • Whole word only
  • Searches for words only, or in other words, searches for a text string that is preceded and followed by a space or punctuation mark.
  • Regular expression
  • Specify whether to recognize regular expressions in the search string.

Scope

  • Global
  • Searches the entire text pane.
  • Selected text
  • Searches only the highlighted text.

Direction

  • Forward
  • Searches from the cursor to the end of the text pane.
  • Backward
  • Searches from the cursor to the top of the text pane.

Origin

  • From cursor
  • Searches from the cursor either forward or backward depending on the Direction setting.
  • Entire scope
  • Searches the entire text pane. If the Direction setting is forward, it starts at the top of the pane. If the Direction setting is backward, it starts at the bottom of the pane.

 

Related Topics

Find Next

SQL Information and Functions > Search Menu > Find Next

The Quick Find search function finds the next occurrence of the text search string that was previously searched for. The function is not available until after you have done an initial search.

To search with Find Next

Select Search | Find Next [F3]

 

Related Topics

Replace

SQL Information and Functions > Search Menu > Replace

The Replace search function brings up the Replace Text window where you can enter

To replace text

Select Search | Replace [Ctrl + Alt + R]

 

Related Topics

Goto Line

SQL Information and Functions > Search Menu > Goto Line

The Goto Line search function brings up the Goto Line window where you can enter the line number that you want to move the cursor to. It is not necessary to have the line numbers displayed in the gutter to use this function, but it would certainly be helpful to see the line numbers in order to select the line number to move the cursor to.

To go to a specific line

Select Search | Goto Line [Ctrl + Alt + G]

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen