The etx_WordFreq() routine
The etx_WordFreq() routine counts the number of documents in a specified index in which a specified word occurs.
Syntax
etx_WordFreq ( index_name, clue )| Element | Purpose | Data type |
|---|---|---|
| index_name | Specifies the name of the search index | LVARCHAR |
| clue | Specifies the search text (this must be a word) | LVARCHAR |
Return type
The etx_WordFreq() utility function returns an INTEGER value that is the number of documents in the specified index in which the specified word appears.
Usage
You can use the etx_WordFreq() utility to get familiar with the data in your etx index. It might be helpful, for instance, to know that a generic word like why appears in every document. You can then add these sorts of words to your stopword list.
Example
The following example counts the
number of documents in the etx index named desc_idx1 in
which the word
multimedia appears: EXECUTE FUNCTION etx_WordFreq('desc_idx1', 'multimedia');