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.
|A single word||
||Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".|
You can specify that the search results contain a specific phrase.
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.
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||
|A combination of search types||
- Methods for updating database dictionary records
- Automatic update of database dictionary records
- Automatic update of RDBMS data when database dictionary records change
- Activate a database dictionary record
- Add a field to an existing database dictionary record
- Import RDBMS columns into an existing database dictionary record
- Modify field types character (scalar) to array
- Modify field types: single to concatenated
- Regen a database dictionary
- Search for a field in a database dictionary
- Update an existing database dictionary record
- Update the data type of a database dictionary field
Search for a field in the database dictionary
Applies to User Roles:
The ability to search the dictionary for a specific field name is particularly useful when dealing with a large database dictionary.
You can search for a field in the database dictionary by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to search for fields.
Search for fields by using System Definition
To search for a field by using System Definition:
From the System Navigator, click System Definition > Tables > file_name > Fields
Note: You can type the first letter of a table name to jump to that alphabetic section. For example, type
oto jump to the oncall table. Double-click a table to open it. Double-click the table to open it.
- Type the first letter(s) of the field you are looking for.
The navigator will go to the first field starting with those letters.
Note: If there is a delay between the letters you type, the Navigator will assume that you want a different search and jump out of the folder to find the matching letters.
Search for fields by using the Database Dictionary utility
Using the Database Dictionary utility when searching for fields enables you do a “contains” search.
To search for a field by using the Database Dictionary utility:
- Click Tailoring > Database Dictionary, and then open the database dictionary file.
From within the database dictionary record you want to search, open the More Actions menu and click Field Search.
This brings up the Field Search window prompt.
- Type the field name to search, for example, one.
- Click Exact match if you are sure that what you entered is a field in the dictionary record.
- Click Starts with to find all fields starting with the string entered.
- Click Contains to search for fields containing the string entered anywhere in the field name. (Used in this example.)
- Click End to cancel the search.
If Service Manager finds a match, it responds by giving a message similar to the following: *Field "phone" found: type=character; level=3; index=2.
The message gives the field type, the level (how many structures down the field where it is located), and the index (location within its parent structure).
For example, one appears in:
- A character type field (phone)
- In the third level structure (alternate.contact)
- As the second field in the alternate.contact structure.
- If multiple fields are found by the search, multiple messages are returned, one message for each field found. The message in the above example displays an asterisk (*), indicating it does have additional messages to display.
View all messages related to this operation.
In this example, these messages reveal that one is present in at least two fields in this database dictionary.
However, since the Contains button was used, the letters are found in their specific order, regardless of where they appear in the field name.
For an exact match on the word one, you can use the Exact match or Starts with button. (Using these options against this example returns no positive hits using Exact match or Starts with.)
Methods for adding database dictionary records
Fields within structures
Methods for updating database dictionary records
Methods for deleting database dictionary records
Adding a key
Modifying a key
Deleting a key
More Actions menu
Add fields to a structure
Add an alias field
Add a field to an existing database dictionary record
Modify field types: Single to concatenated
Modify field types: Character (scalar) to array
Remove a field from an existing database dictionary record
Open a database dictionary
Access the Database Dictionary utility
Regen a database dictionary