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	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.50

Develop > Tailoring Best Practice Guide > Database (RDBMS) mapping > When are RDBMS mappings added or updated?

When are RDBMS mappings added or updated?

Service Manager must have proper RDBMS rights to directly change RDBMS mappings. If the system does not have these rights, it will not add or update any RDBMS mappings.

Service Manager issues CREATE TABLE statements to create RDBMS mapping in the following circumstances:

You create a new file (a logical view of a table) in a database dictionary record
You create new fields (a logical view of a column) in a database dictionary record

Service Manager issues ALTER TABLE statements to update existing RDBMS mappings in the following circumstances.

You change a fixed-width character field mapping to a variable-width character field mapping
You change a variable-width character field mapping to a fixed-width character field mapping
You widen a column
You rename a column
You rename a table

Service Manager issues DROP TABLE statements to delete existing RDBMS mappings in the following circumstances.

You remove a table entry the SQL Table field in a database dictionary record
You remove a table from the SQL Tables file

Service Manager does a full table copy of an existing table in the following circumstances.

You change the RC flag for any field in a database dictionary record
You change a field alias that is not mapped to a NULLTABLE alias
You associate a new main or alias table to an existing database dictionary record
You change the RDBMS connection information to use a new type of RDBMS

Send Help Center feedback