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.52

Administer > Database administration > Data persistence > Keys and indexes in HPE Service Manager > Modifying a Key > Modify keys: Nulls and Duplicates to Unique

Modify keys: Nulls and duplicates to unique

Applies to User Roles:

System Administrator

You can modify keys by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to modify keys.

Modify keys by using System Definition

To modify keys by using System Definition:

From the System Navigation, click System Definition > Tables > Database Definition > Keys > key name
Right click Edit.
Make your changes.
Click OK.
Right click Save on the Database Definition node to save your changes.

Modify keys by using the Database Dictionary utility

Example: Change the key type for operators in a copy of the assignment file from Nulls & Duplicates to Unique. If data already exists in the file, ensure that a unique value also exists in the operator field for every record in the file. If this condition is not met, you will then have to update each record individually or perform a Mass Update.

To modify keys by using the Database Dictionary utility:

Open the assignment dbdict.
Make a copy of the assignment dbdict named assignment2.
Position the cursor on the key type Nulls & Duplicates above the key field operators.
Click Edit.
In the Type field, type: unique.
Click OK to close the window and commit the changes to the file.
You can now reedit your database dictionary record, update it, or cancel without updating.
Click OK to close and automatically update the file.
This returns the message Record updated in the dbdict file.

Send Help Center feedback