Chatee ahora con Soporte
Chat con el soporte

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Search Functions

The Search functions search through the current text pane to find the text search string. This applies to text pane that are editable with a white background (Windows default color) and the panes that are read only with a gray background (Windows default color).

These functions are available from the Search menu:

Quick Find

Find

Find Next

Replace

Goto Line

For windows that have multiple tabs in the text pane, use the Find option on the SQL menu to search though all the tabs for the text search string.

 

Find

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

To search for text the currently displayed SQL statement

  1. Select Search | Find [Ctrl + F].

  2. Enter the search string.  

The search is refined in the Find Text window using the following settings:

Options

Search Option

Description

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

Scope Options

Description

Global

Searches the entire text pane.

Selected text

Searches only the highlighted text.

Direction

Direction Options

Description

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

Origin Options

Description

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.

 

Quick Find

The Quick Find search function searches the currently displayed SQL statement for the next occurrence of the text that you have highlighted in the SQL statement. If it finds this text, it moves the line containing the search string to the top of the text pane.

To find the currently highlighted text

With text highlighted in the active window, select Search | Quick Find [CRTL + ALT + F].

 

Find Next

The Quick Find search function finds, in the currently displayed SQL statement, the next occurrence of the text search string that you previously searched for. The function is not available until after you have done an initial search.

To find the next occurrence of the search string

Select Search | Find Next [F3].

 

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación