SEARCH_SCRIPT_FOR_USAGE
Client-wide variable that controls the search for object use in scripts.
-
Description:
When deleting, renaming or manually searching for the use of an object, the Automation Engine checks if this object is used in other objects too. If so, you can have a list of all these objects displayed.
-
Allowed values:
-
Y
Objects that are used in scripts are included in the search.
The searched string is handled as a word that is enclosed in delimiters such as blanks, left and right parentheses, equals, commas, single quotations, double quotations, end of lines and script ends.
For example: Searching for MM only lists results in which this term is enclosed in the listed delimiters.
- (MM)
- =MM=
- 'MM'
- (MM,
- =MM at the end of a line
Notes:
- Underscores are not delimiters. Searching for MM is not successful if you search for _MM_
- this search specification is only supported for the MS SQL Server and Oracle version 10g and beyond
- Searching by using the option "Y" is more complex and takes longer
-
L
Objects that are used in scripts are included in the search.
The searched string must be somewhere in the script as otherwise, it is not displayed as a search result.
For example: Searching for MM lists results in which this term is included as a whole or partially.
- MM
- MM.CLOSING
- AE.MM.DAY
Note: Search result are limited to 1000 entries for performance reasons.
-
N
No search for object usage in scripts
-
-
Default value:
N
-
Restart required:
No
See also: