The etx_DropCharSet() routine

The etx_DropCharSet() routine drops a user-defined character set.

Syntax

etx_DropCharSet (charset_name)


Element	Purpose	Data type
charset_name	Name of the user-defined character set you want to drop	CHAR (18)

Return type

None.

Usage

Use the etx_DropCharSet() routine to drop an existing user-defined character set. The database server drops the user-defined character set as long as no index is currently using it.

Important: Use the routine etx_DropCharSet() to drop only user-defined character sets that are currently not being used by any etx indexes. If you want to change the character set being used by an index, you must first drop the index and then recreate it, specifying the name of the new character set through the CHAR_SET index parameter.

To determine if a user-defined character set 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 '%charset_name%';

where charset_name refers to the name of the user-defined character set you want to find information about. The search is case sensitive, so enter the name of the user-defined character set exactly as it was created.

If the query returns no rows, no index is currently using the specified user-defined character set. If the query returns one or more rows, the index or indexes returned in the idxname column are currently using the specified user-defined character set. 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 user-defined character set my_charset:

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

Example

The following example drops the user-defined character set my_charset:

EXECUTE PROCEDURE etx_DropCharSet ('my_charset');