Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
|A single word||
||Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".|
You can specify that the search results contain a specific phrase.
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.
Two or more words in the same topic
|Either word in a topic||
|Topics that do not contain a specific word or phrase||
|Topics that contain one string and do not contain another||
|A combination of search types||
- Methods for updating database dictionary records
- Automatic update of database dictionary records
- Automatic update of RDBMS data when database dictionary records change
- Activate a database dictionary record
- Add a field to an existing database dictionary record
- Import RDBMS columns into an existing database dictionary record
- Modify field types character (scalar) to array
- Modify field types: single to concatenated
- Regen a database dictionary
- Search for a field in a database dictionary
- Update an existing database dictionary record
- Update the data type of a database dictionary field
Modify field types: Character (scalar) to array
Applies to User Roles:
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:
- 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:
- In the Type field, type:
- 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:
- 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, we recommend 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
Fields within structures
Methods for adding database dictionary records
Methods for updating database dictionary records
Methods for deleting database dictionary records
Adding a key
Modifying a key
Deleting a key
Access the Database Dictionary utility
Add fields to a structure
Modify field types: Single to concatenated
Open a database dictionary
Regen a database dictionary
Search for a field in the database dictionary