The LOAD ONLY Start List will be applied only during loading.

Use the Start List of the Translate Table to define only specific words to be indexed. The Start List provides a simple means of categorizing data. If a Start List exists, only words found within the Start List are indexed. All other words are discarded. However, it is not the word itself that is indexed. Instead, there is a replacement word associated with the start word. It is that word which is indexed without any further replacement or stemming.

The major use of a Start List is in categorizing data. A category is created by associating a number of individual start words with the same replacement word. Once the desired number of categories have been created within the Start List, the list can be used with an index created over the data to categorize it for searching or histogramming.

The Start List is composed of two columns of words. The words in the first column represents the Pattern, the words to be found in the data, and the second column represents the Replacement, or the words to be indexed in place of their corresponding Pattern.

Example Start List to categorize records by make of automobile