Online Documentation for SQL Query for DB2
Find Text dialog
The Find Text dialog is provided for quick and flexible searching for specified text within the SQL Editor working area.
Text to find
Enter a search string in this box. The Arrow-Down button which can be found next to the input box allows you to select any of the previously entered search strings.
Options
Case Sensitive
This option can be used to differentiate uppercase characters from lowercase ones during the search process.
Whole words only
Use this option to search for words only (with this option off, the search string might be found within longer words.)
Regular Expressions
Recognizes regular expressions in the search string.
Direction
Forward
Searches from the current position to the end of the SQL Editor area.
Backward
Searches from the current position to the beginning of the SQL Editor area.
Scope
Global
Searches within the entire SQL Editor working area, in the direction specified by the Direction setting.
Selected text
Searches only within the currently selected text, in the direction specified by the Direction setting. You can use the mouse or block commands to select a block of text.
Origin
From cursor
The search starts at the cursor's current position, and then proceeds either forward to the end of the scope, or backward to the beginning of the scope depending on the Direction setting.
Entire scope
The search covers either the entire block of selected text or the entire script (no matter where the cursor is in the Editor area) depending upon the Scope options.