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 > Valid data type changes

Valid data type changes

You can only change existing database dictionary mappings under certain conditions. If your database dictionary change does not fall within one of the following conditions, you will have to create a new database dictionary mapping to replace the existing mapping.

Valid data type changes
Starting data type	New data type	Example
Fixed-length character field	Variable-length character field with the same column length	Change a CHAR(10) mapping to a VARCHAR(10) mapping
Variable-length character field	Fixed-length character field with the same column length	Change a VARCHAR(10) mapping to a CHAR(10) mapping
Fixed-length character field	Fixed-length character field with a longer column width	Change a CHAR(10) mapping to a CHAR(15) mapping
Fixed-length character field	Variable-length character field with a longer column width	Change a CHAR(10) mapping to a VARCHAR(15) mapping
Variable-length character field	Variable-length character field with a longer column width	Change a VARCHAR(20) mapping to a VARCHAR(40) mapping
Variable-length character field	Fixed-length character field with a longer column width	Change a VARCHAR(20) mapping to a CHAR(40) mapping

In addition to changing a column data type, you can also rename a column or a table.

Valid name changes
Database dictionary item	Equivalent RDBMS item	Example
File name	Table name	Change a table name from MY_TABLE to SAMPLE_TABLE
Field name	Column name	Change a column name from MY_COLUMN to SAMPLE_COLUMN

Send Help Center feedback