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

Regular Expression

Regular expressions are characters that customize a text search string. They formulate a more complex search.

You must select the Regular expression checkbox to use these advanced search features.

Type of Search

Search Characters

Location of character in the search string

Explanation

Text at the beginning of line

^ (circumflex)

Example:^select

Beginning A circumflex at the beginning of the text search string finds the text only if it is the first non white space text on a line

Text at the end of line

$ (dollar sign)

Example:error$

End A dollar sign at the end of the expression matches the end of a line.

Single character wildcard

. (period)

Example:f.r

matches "for" and "‘far"

Any place A period represents any character.

Class of character

: (colon)

Example:SQL:a

finds SQLSTATE or SQLTABLE

SQL:d

Finds SQL1 or SQL3

Any place

A colon matches a class of characters described by the character following the colon.

:a

matches any alphabetic character

:d

matches a digit

:n

matches an alphanumeric character

": "

matches a space, tab, or other control character or punctuation mark (ASCII 0x01 - 0x40)

Search for Regular Expression characters

\ (backslash)

Example: \^ searches for ^

\\ searches for \.

Any place A backslash before a wildcard character searches for actual character and does not use the character as a wildcard.

Search for multiple characters in one position

[...] (characters within square brackets

Example:r[au]n

finds run or ran

Any place Characters enclosed in square brackets matches any one character that displays in the brackets, but no others. Nesting of brackets is not supported.

Search for any character but the specified characters in one character position

[^] (circumflex within square brackets)

Example: r[^oa]n

finds run, r n, rin, etc but not ron or ran.

Any place A circumflex at the start of the string in square brackets means NOT. The expression matches any character except the characters in the string and the carriage return (ASCII 0x0D) or line feed (ASCII 0x0A).

Search for a range of characters in one character position

[-] (hyphen within the square brackets)

Example: SQL[1-3]

finds SQL1, SQL2 and SQL3

Any place

A hyphen within the square brackets signifies a range of characters.

Note: the range must be in a progressive order, i.e. "[a-x]" matches any character from a through x while "[x-a]" does not match anything.

 

Related Topics

Code Finder Overview

Code Finder Window

Extract Object DDL to File

Save Search Results

Code Finder Functions

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

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

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

Related Documents