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||
- 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
- Renaming a database dictionary
- Resetting a database table
Database dictionary data types
Every field in a database dictionary record requires a data type value to determine the format of the data in the field.
Database dictionary records use an abstract data type that the Service Manager server uses to determine how to map your system data to the SQL data type required by your RDBMS.
For example, the database dictionary data type "number" maps to FLOAT in Microsoft SQL server and maps to NUMBER in Oracle.
For a complete listing of how the database dictionary data types map to RDBMS data types, use the Database Manager utility to view the records in the
Caution Do not change the data type mappings in the sqldbinfo table unless directed to do so by customer support. Changing these values can result in data loss or corruption.
Note Starting with Service Manager 9.40, the sqlserver record in the sqldbinfo table contains a read-only flag named Use Unicode Data Type to indicate if Microsoft SQL Server uses the Unicode data type (nvarchar).
The Service Manager server does not automatically validate field data to ensure that it matches the data type defined in the database dictionary record. If you want to validate your data prior to submitting it to the RDBMS, you have several options:
- You can customize your forms so that the input field matches the data type. By default, Forms Designer uses the data type to determine the input object to use when you drag a field on to a form.
- You can create a data policy record for the table and then create validation rules for each field in the table you want to validate.
- You can create a format control record for the table and then create validation rules for each particular record state such as add, update, delete, or initial display.
Once you save data to Service Manager, the RDBMS controls the data type and any validation. If you change the data type on the RDBMS side, Service Manager can update the database dictionary record to match the RDBMS data type with a system restart of the server. We recommend you control data types from the database dictionary so you do not have to restart your system every time you make a change to a field.
Service Manager data types also allow you to take advantage of the following advanced features.
- You can move your system data from one RDBMS type to another
- You can map system data to multiple RDBMS types at the same time
You can use the SQL to SQL Conversion utility to enable one or both of these advanced features. The SQL to SQL Conversion utility allows you to move or map data on a table by table basis. It also allows you to customize how you want data in array fields to be mapped in the new RDBMS as well as offering several export options such as creating DDL or creating duplicate tables.