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

Code Finder

Code Finder Overview

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.

 

Related Topics

Code Finder Window

Regular Expression

Open Database Object or File in SQL Worksheet

Extract Object DDL to File

Save Search Results

Code Finder Functions

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.

 

Related Topics

Code Finder Window

Open Database Object or File in SQL Worksheet

Extract Object DDL to File

Save Search Results

Code Finder Functions

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.

 

Related Topics

Code Finder Window

Open Database Object or File in SQL Worksheet

Extract Object DDL to File

Save Search Results

Code Finder Functions

Related Documents