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 |
|
- 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
Automatic update of RDBMS data when database dictionary records change
The Service Manager server can push changes you make in the database dictionary to your back-end RDBMS. If you provide the Service Manager server with table create-alter-drop-rights to the RDBMS, it automatically adds or updates any tables, columns, or indexes needed in the RDBMS. If you do not provide the Service Manager server table create-alter-drop-rights to the RDBMS, we recommend you enable exporting your database dictionary changes as DDL. This allows you to make the necessary changes to the database dictionary and then have your RDBMS administrator review and implement the DDL on the RDBMS.
To trigger the automatic update of RDBMS data, you add or update a database dictionary record and save it. When you save the database dictionary record, Service Manager consults the mapping format for your RDBMS to create the corresponding tables, columns, and indexes required by your addition or change. Service Manager then connects to the RDBMS with the user account you provided in the configuration file and attempts to add or update the database. If the add or update is successful, you will see the updated mapping for the table, column, or index after you restart Service Manager. If the add or update fails, the Service Manager server changes the database dictionary mappings to map to null tables and writes an error message in the Service Manager log file.
For example, suppose the Service Manager administrator creates a new database dictionary called testtable.
The testtable database dictionary consists of two fields: a number field called test.id and a character field called test.name.
The administrator makes the test.id field the unique key.
After saving the new database dictionary record, the administrator views the database dictionary record to see how they are mapped to tables and columns in the RDBMS.
On a Microsoft SQL Server, the testtable database dictionary might map to the following tables and columns.
Sample database dictionary for the test.id number field
| Database dictionary object | Value if RDBMS table create-alter-drop-rights granted | Value if RDBMS table create-alter-drop-rights denied |
|---|---|---|
| Database dictionary field name | test.id | test.id |
| Database dictionary data type | number | number |
| SQL column name | TEST_ID | TEST_ID |
| SQL data type | FLOAT | FLOAT |
| SQL alias | m1 | N-m1 |
| SQL table name | TESTTABLEM1 | NULLTABLE |
Sample database dictionary for the test.name character field
| Database dictionary object | Value if RDBMS table create-alter-drop-rights granted | Value if RDBMS table create-alter-drop-rights denied |
|---|---|---|
| Database dictionary field name | test.name | test.name |
| Database dictionary data type | character | character |
| SQL column name | TEST_NAME | TEST_NAME |
| SQL data type | VARCHAR(60) | VARCHAR(60) |
| SQL alias | m1 | N-m1 |
| SQL table name | TESTTABLEM1 | NULLTABLE |
When Service Manager has table create-alter-drop-rights to the RDBMS, the database dictionary record contains mapping information to the actual tables and column names. When Service Manager does not have table create-alter-drop-rights to the RDBMS, the database dictionary record contains mapping information to the proposed table and column names. The RDBMS administrator can use Service Manager’s generated DDL to create the proposed table and column names. Until the actual tables and columns exist, the database dictionary record points to a null table mapping. All null table aliases start with an "N-" prefix, and the SQL table name maps to the value NULLTABLE. After the RDBMS administrator has created the tables and columns for the database dictionary record, the Service Manager administrator can use the Activate Nulltable Rows option to update the SQL mappings to their new values. Service Manager will use the column names listed in the database dictionary record to match it to the proper table name in the RDBMS.
Related topics
Automatic update of database dictionary records
Database dictionary
Database dictionary records
Activate a database dictionary record
Create an active database dictionary record
Create an inactive database dictionary record
Import RDBMS columns into an existing database dictionary record
