The etx_DropStopWlst() routine

The etx_DropStopWlst() routine drops a stopword list.

Syntax

etx_DropStopWlst (list_name)


Element	Purpose	Data type
list_name	Name of the stopword list you want to drop	CHAR (18)

Return type

None.

Usage

Use the etx_DropStopWlst() routine to drop an existing stopword list. The database server drops the stopword list as long as no index is currently using it.

Important: Use the routine etx_DropStopWlst() to drop only stopword lists that are currently not being used by any etx indexes. If you want to change the stopword list being used by an index, you must first drop the index and then recreate it, specifying the name of the new stopword list.

To determine if a stopword list is currently being used by an etx index, query the system catalog tables, as shown by the following sample query:

SELECT idxname, amparam
FROM sysindices
WHERE amparam like '%stopwordlist_name%';

where stopwordlist_name refers to the name of the stopword list you want to find information about. The search is case sensitive, so enter the name of the stopword list exactly as it was created.

If the query returns no rows, no index is currently using the specified stopword list. If the query returns one or more rows, the index or indexes returned in the idxname column are currently using the specified stopword list. The amparam column of the sysindices system table stores the index parameters used to create the etx index.

For example, the following query returns a row for each etx index that is currently using the stopword list my_stopwordlist:

SELECT idxname, amparam
    FROM sysindices
    WHERE amparam LIKE '%my_stopwordlist%';

Example

The following example drops the stopword list named my_stopword:

EXECUTE PROCEDURE etx_DropStopWlst ('my_stopword');