Remap array fields to an alias table

To improve your query performance, you can move an existing array field or an array of structure field to an alias table (for example, a1).

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)`

The " field in alias" and "BLOB in alias" mapping formats are deprecated. The multi-row array mapping format is recommended.
You can revert your remapping changes by moving the field back to the main table and restoring the original SQL configuration.

Array

You can remap an array field to an alias table using the multi-row array mapping format.

To remap an array field using the multi-row array mapping format, follow these steps:

Type dbdict in the command line, and press Enter.

Open the dbdict that you want to update by performing a search.

Select the Fields tab.

Select the field of the array type, and click Edit Field/Key.

Enter a value in the fields as described in the following table.

Note As an example, the following table lists the SQL Type values allowed for an array of characters. For other types of arrays, the allowed SQL Type values may differ.

Mapping format	SQL Name	SQL Type	SQL Table	SQL RC
Multi-row array	MULTI_ROW_ARRAY	TEXT, varchar, char, nvarchar, or nchar	a1	False

Click OK.

Array of structure

To remap an array of structure using the multi-row array mapping format, follow these steps:

Type dbdict in the command line, and press Enter.

Open the dbdict that you want to update by performing a search.

Select the Fields tab.

In the array of structure, select the top level field (whose type is array), change its SQL Table field value to a1 and leave the rest of the fields empty.

Select the middle level field (whose type is structure), and make sure its SQL Name, SQL Type, and SQL Table fields are empty.

Select each element under the structure, and enter a value in the fields as described in the following table.

Note As an example, the following table lists the SQL Type values allowed for a structure element of the character data type. For elements of other data types, the allowed SQL Type values may differ.