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

Administer > Database Administration > Data persistence > Database dictionary > Methods for adding database dictionary records > Add a structure to the database dictionary

Add a structure to the database dictionary

Applies to User Roles:

System Administrator

You can add a structure to the database dictionary by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to add a structure.

Note: You must use the Windows client whenever you need to add a new field/key to a database dictionary table.

Add a structure by using System Definition

To add a structure by using System Definition:

In the System Navigator, click System Definition > Tables > filename > Fields.
Click New Field.
Type a name in the Field Name field.
Click OK. The new field name is now listed in its alphabetical place in the fields list.
Select the new field from the list, and in the General properties section select Structure in the Data type field, and then specify other general properties and SQL mappings properties for the field.
Select the structure field from the Fields list, and click New Field.
Type a name in the Field name field, and click OK. The field is added to the structure.
Specify general properties, aliases, and SQL mapping properties for the field.
Repeat steps 6 through 8 to add more fields to the structure.
Click Save to save the file.

Add a structure by using the Database Dictionary utility

This example illustrates how to add a structure that contains fields for basic employee information. The fields are name, telephone number, and address. These fields will appear on all formats or views of the employee file. Salary, hire.date, review.date, rehire, termination.date, position, and department will appear only on certain forms.

To add a structure by using the Database Dictionary utility:

From the database dictionary, open the employee file.
On the Fields tab, place the cursor on the descriptor structure.
Click New Field/Key.
In the Name field, type basic.employee.info.
In the Type field, choose structure from the Type list.
Click Add.

You can now add fields within the structure you just created.
In the Name and Type fields, type a name and select a data type for the first field you want to add to the structure. For example, type person.name and select character.
Click Add.

The structure with its first field is added to the Fields tab.
On the Fields tab, select the structure field you added, and click New Field/Key to add more fields to the structure field. For example, add two more fields named telephone (data type: character) and address (data type: character) .
Click OK to save your edits.
Click SM Alters when you are asked how you want to update the database dictionary.

This returns the message: Record updated in the dbdict file.

Send Help Center feedback