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

Administer > Database Administration > Data persistence > Database dictionary > Database dictionary data types > Change data types: character to number

Change data types: Character to number

Applies to User Roles:

System Administrator

You can change data types by using System Definition, by using Mass update, or by using the Database Dictionary utility.

Change data types by using System Definition

To change data types by using System Definition:

In the System Navigator, click System Definition > Tables >table_name> Fields > field_name.
Double-click the field name.
In the General properties tab, select a new type from the Data type list.
Click Save.

Change data types by using Mass Update

In this example, records have a character in the zip field that is now defined as a number field.

If some of the records in the file contain data in the modified field that invalidates the new field type, the data is not converted and the system generates a "cannot evaluate" message for each record failing the conversion.

Service Manager updates only those records that do not fail the conversion.

To change data types by using mass update, use the syntax: zip in $file=nullsub{val(zip in $file,1),zip in $file}.

Change data types by using the Database Dictionary utility

This example illustrates how to change the field called zip in the vendor file from a character type field to a number type field. Assume that data exists in the file.

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

To change data types by using the Database Dictionary utility:

Click Tailoring > Database Dictionary.
Type vendor in File Name field, and then click Search.
Select the zip field name.
Click Edit Field/Key.

The field editing window opens.
In the Type field, choose number in the Type list selection.

This replaces character with number in the Type field.
Click OK to close the window and commit the change to the file.
Click OK to update your database dictionary record.

The message Record updated in the dbdict file displays to confirm the update.

Note: This may not be the end of the process. If records exist in the file, you need to perform a Mass Update to change the field type of the zip field from character to number. (The type of field, for example, character, number, or date/time is stored in the data record with each associated value).

All records containing a value in the field zip need to be updated to reflect the new field type. For additional information on the Mass Update procedure, see the Database Manager Help.

Send Help Center feedback