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.
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. |
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
- Database dictionary records
- Making database dictionary changes
- Database dictionary data types
- Alias fields
- Access the database dictionary utility
- Enable DDL logging of database dictionary changes
- Open a database dictionary
- Copying a database dictionary
- Methods for adding database dictionary records
- Methods for deleting database dictionary records
- Methods for updating database dictionary records
- Resetting a database table
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Unload script utility
- Purging and archiving records
- Add, delete or update a master data record
- Database record auditing
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
- Database dictionary
Database dictionary
Service Manager maintains a logical view of your RDBMS tables and columns in the database dictionary. The database dictionary describes each table and column in your system and how they are mapped to logical entities within Service Manager. The Service Manager applications use the logical definitions in the database dictionary to query and manage the actual records in your RDBMS. You must create a database dictionary record for each table and column in your system.
Every time you add tables and columns for Service Manager to your RDBMS system, you must also create database dictionary records describing these new items before Service Manager can make use of them. The best practice we recommend is to create the database dictionary records first, and then have Service Manager create the back-end tables and columns for you automatically. Some environments, however, do not permit Service Manager to add or update records in the back-end RDBMS.
In restricted-access RDBMS environments, Service Manager can create database definition language (DDL) describing the changes proposed by your database dictionary records. The RDBMS administrator can then create the necessary tables and columns for Service Manager . After the RDBMS has the necessary tables and columns, the Service Manager administrator can then update the database dictionary records to map to the actual RDBMS objects. To simplify the mapping process, Service Manager administrators can also import columns from an RDBMS into a database dictionary record.
You can access database dictionary records either from the System Definition utility or from the database dictionary form.
Both utilities require having the SysAdmin
capability word or its equivalent.
We recommend using the System Definition utility to create database dictionary records if Service Manager has table create-alter-drop-rights to the RDBMS.
If your environment restricts access to the RDBMS, we recommend using the database dictionary form to create the initial null mappings and then update the database dictionary by importing the RDBMS tables and columns.
To provide Service Manager with table create-alter-drop-rights to your RDBMS, you must add the RDBMS connection parameters to the server configuration file (sm.ini). The RDBMS user name you provide Service Manager must at least have add and drop access rights. We recommend you grant the RDBMS user owner rights over the database so that Service Manager can manage the data as needed.
To have the server create DDL for database dictionary changes, you must add the sqlddllogging
and sqlddldirectory
parameters to the server configuration file (sm.ini).
The server creates one DDL file for each logical table in the database dictionary.
For example, the file prosummary.ddl contains DDL for changes made to the probsummary database dictionary record, which in turn, maps to the physical tables such as PROSUMMARYA1, PROSUMMARYM1, and PROSUMMARYM2 in your RDBMS.
You can enable exporting to DDL independently of providing Service Manager with table create-alter-drop-rights to the RDBMS.
You may want to export all RDBMS changes to DDL to keep a log of changes to your RDBMS.
Related topics
Data persistence
Automatic update of database dictionary records
Automatic update of RDBMS data when database dictionary records change
Database dictionary data types
Database dictionary records
Create a database dictionary record by importing RDBMS columns
Create an active database dictionary record
Create an inactive database dictionary record
Enable DDL logging of database dictionary changes
Import RDBMS columns into an existing database dictionary record