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 > Methods for updating database dictionary records > Modify field types character (scalar) to array

Modify field types: Character (scalar) to array

Applies to User Roles:

System Administrator

Example: Change a field with existing data, called address, from a character type scalar field to an array. For this example, assume that we created a new file called vendorview from the format vendor.

To modify field types, character (scalar) to array:

Select the address field name. Only one entry for address should appear, as it is currently a scalar field.
Click Edit.
In the Name field, type: old.address.
Leave the Type field value as character.
Click OK to close the window and commit the change to the file.
The address field name is now old.address in the Field Name array.
Select the descriptor structure, and then click New.
In the Name field, type: address.
In the Type field, type:array.
Click Add to commit the new array to the file.
When adding an array field, you also need to specify the type of array (for example, character, number, date/time, etc.). Service Manager prompts you for this information now.
A new field.window opens with address displayed in the Name field and the Type field blank. The message Enter data type of array’s element also appears at the bottom of the format window.
Select the Type field and type:character.
Click Add.
Notice two entries for address now exist in the database dictionary record since it has been defined as a character array.
Click OK to close the window and save the changes.
Click OK to end this session with the vendorview file.

The field type has been changed, but this is not the end of the process.

Because data exists in the file, you need to move the contents of the field now called old.address to the field called address. To accomplish this, perform a Mass Update in Database Manager on all records in the file that have data in the old.address field.

Once the data has been moved, HPE recommends that you also remove the old.address field from the database dictionary record.

The Mass Update instruction string to move the data from the field called old.address to the first element in the newly created array called address is:

1 in address in $file = old.address in $file

Send Help Center feedback