지금 지원 담당자와 채팅
지원 담당자와 채팅

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

Open Database Object or File in SQL Worksheet

Code Finder > Open Database Object or File in SQL Worksheet

You can open the matched database objects and files in the SQL Worksheet after performing the Search function in the Code Finder window.

To open the database object or file in the SQL Worksheet

Right-click the object or file and select Open in SQL Worksheet.

The database object’s DDL or the file opens on the SQL Worksheet window and the cursor displays at the beginning of the matching text.

 

Related Topics

Code Finder Window

Extract Object DDL to File

Save Search Results

Code Finder Functions

Extract Object DDL to File

Code Finder > Extract Object DDL to File

In the Code Finder window, you can extract the DDL to a file for the database objects that contain the search string.

To extract the DDL from an object

  1. Perform a search.

  2. Select the object from the lower pane.

  3. Click Extract to file.

  4. Enter a name for the DDL file.

 

Related Topics

Code Finder Window

Extract Object DDL to File

Save Search Results

Code Finder Functions

Save Search Results

Code Finder > Save Search Results

You can save the search results from the Code Finder in a file.

To save the search results

  1. Right-click and select Save.
  2. Select to formate the file as Text, HTML, or Excel Convertible (Spreadsheet).

 

Related Topics

Code Finder Overview

Code Finder Window

Extract Object DDL to File

Code Finder Functions

Code Finder Functions

Code Finder > Code Finder Functions

Below is a list of available functions within the Code Finder window.

Menu

Function

  Search

 

Abort

 

Extract to File

 

New Search

Right-click Menu

Open in SQL Worksheet

Right-click Menu

Save

 

Related Topics

Extract Object DDL to File

Open Database Object or File in SQL Worksheet

Save Search Results

Code Finder Overview

Code Finder Window

Regular Expression

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택