Stopword lists
A stopword is a word that you want excluded from your index and, as a consequence, from your searches. A typical stopword list includes words like of, the, and by. Stopword lists depend on the content and type of your data.
Any frequently occurring word that you want excluded from your index is a candidate for inclusion in a stopword list. Stopword lists can reduce the time it takes to perform a search, reduce index size, and help you avoid false hits.
EXECUTE PROCEDURE etx_CreateStopWlst
('stopwlist', '/local0/excal/stopwlist');
This statement creates the stopword list stopwlist from the operating system file /local0/excal/stopwlist. An optional third argument can be used to specify the sbspace where the list is to be stored. If you do not specify a specific sbspace to store the list, it is stored in the default sbspace. The default sbspace is specified by the SBSPACENAME parameter in the onconfig file.
$ONEDB_HOME/extend/ETX.version/wordlist/etx_stopwords.txt
where version is
the current version of the DataBlade module
installed on your computer. You can have at most one stopword list associated with an etx index. The stopword list is specified when the index is initially created with the index parameter STOPWORD_LIST. The stopword list must exist when the etx index is created.
to be or not to be
as follows:SELECT id, description FROM videos
WHERE etx_contains(description,
Row('to be or not to be',
'SEARCH_TYPE = PHRASE_EXACT & CONSIDER_STOPWORDS'));
INCLUDE_STOPWORDS='TRUE'
index
parameter is specified for the CREATE INDEX statement that creates
the etx index.