Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
- Data persistence
- Database dictionary
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Unload script utility
- Purging and archiving records
- Master data records
- Database record auditing
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
Unload script utility
The unload script utility enables system administrators to create Service Manager unload files automatically. The unload script utility enhances the standard unload creation process in many ways. With unload scripts, you can:
- Save records from multiple tables into a single unload file.
- Specify a query for each source table that filters the records added to the unload file.
- Purge records during the unload process.
- Specify which formats to protect during a purge process.
- Add related records from the data map file to the unload file.
The unload script utility is available in Tailoring. By default, Service Manager includes a collection of unload scripts that you can use for common unload tasks. You can also use the default unload scripts as templates to create your own customized unload scripts.
To create and use unload scripts effectively, you must be familiar with the Service Manager Database Manager. You can create a query on any field in the file, but querying keyed fields improves system performance and response time. You can create record queries using Structured Query Language (SQL) syntax.
You can use the Purge/Archive utility to unload and purge records from one file; if you use datamaps, you can use Purge/Archive to unload and purge related records as well.
After you load a .unl file to import data into Service Manager, you must stop and then restart the Service Manager server. This ensures that the table changes are initialized.
Note: The Unload Script utility unloads tables using the binary unload file format.
Related topics
Applying customizations to the production environment
Data maps
Environment configuration
Exporting records
Importing records
Purging and archiving records
Master data records
Using data maps to purge and archive records
Add an unload script record
Delete an unload script record
Protect forms from the unload script utility
Purge records with the unload script utility
Run an unload script
Update an unload script record
Validate an unload script record
