The etx_CreateStopWlst() routine
The etx_CreateStopWlst() routine creates a list of words that the text search engine ignores when it performs a search or builds an index.
Syntax
etx_CreateStopWlst (list_name, file_name, sbspace)
Element | Purpose | Data type |
---|---|---|
list_name | Name of your stopword list. If you enter a name longer than 18 characters, the name is silently truncated to 18 characters. | CHAR (18) |
file_name | Absolute path name of the operating system file from which the text search engine loads the stopwords. The file can be on either the server or the client machine. The routine searches the client machine first. | LVARCHAR |
sbspace | Optional parameter to specify the sbspace in which you want to store the stopword list. If you do not specify an sbspace, the database server stores the stopword list in the default sbspace. | CHAR (18) |
Return type
None.
Usage
Use the etx_CreateStopWlst() routine to store a stopword list in an sbspace.
A stopword list is a list of words that you want eliminated from both an etx index and the text search clue. A typical word list might include the prepositions of, by, with, and other prepositions. Eliminating stopwords from the search process can significantly improve the performance of your searches.
$ONEDB_HOME/extend/ETX.version/wordlist/etx_stopwords.txt
where version is
the current version of the DataBlade module
installed on your computer.Examples
EXECUTE PROCEDURE etx_CreateStopWlst
('my_stopword', '/local0/excal/stp_word', 'sbsp1');
The search engine stores and loads the contents of my_stopword from the operating system file /local0/excal/stp_word. The etx_CreateStopWlst() procedure stores the stopword list in an sbspace named sbsp1.