SQL Optimizer for SAP ASE 3.9

The Code Finder searches database objects and files for a specific text string. Each occurrence of the specified text is listed and the database objects or files where it is found.

Code Finder Window

Code Finder > Code Finder Window

The Code Finder window is divided into three sections: search criteria, where to search, and the search result.

Search Criteria

The search criteria displays on the top left pane. Review the following for additional information:

Item	Description
Text	Specify text.
First occurrence only	Specify whether to search for only the first occurrence of the text in the database object or file. If this option is not selected, all occurrences of the text displays.
Case sensitive	Specify whether to search for the text in exact case that you enter it.
Whole word only	Specify whether to search for words only
Regular Expression	Specify whether to recognize regular expressions in the search string.

Where to Search

Select where you want to search. Review the following for additional information:

Item	Description
Look in	Displays the list of selected objects and files to search.
Quick Find	Allows the selection of the database objects belonging to the current database and user (Tables, Views, Procedures, Triggers, Rules, Defaults) and/or the selection of all files belonging to the selected directory.
Database Objects	Allows the browsing and selection of database objects from different databases and users.
Directories/Files	Allows the browsing and selection of directories or files. .

Search Result

The lower pane displays the list of items that matches the search criteria. Review the following for additional information:

Item	Description
Name	Database object or file name.
Line	Line number of matched specified text.
Text	Line of text showing the matched specified text.

Search Database Objects and Files

Code Finder > Search Database Objects and Files

To display the Code Finder window

Click .

Enter a search text or use the down arrow next to the input field to select from a list of previously entered search text. The First occurrence only, Case sensitive, Whole word only andRegular expression checkboxes lets you refine the search.

For database objects

Select the Quick Find tab to select objects belonging to the current database and user. Or, select the Database Objects tab. Expand the object and select user, object type or object name and click Add. The selected object displays in the Look in pane on the top left indicating that the selected objects will be searched. No duplicate objects can be selected.

For directories and files

Select the Directories/Files tab. Select the directory and enter a file mask or click the down arrow to select from a list of previously entered file marks. If blank, *.* is used indicating that all files will be searched. To search in the sub-directory, select Include sub-directories checkbox. Click Add to select the directory and files. No duplicate files can be selected.

To start searching

Click Search.

To stop the search

Click Abort.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.9 - User Guide

Code Finder

Code Finder Overview