Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

RESET INDEX STATUS

When the index status of a table or column shows Search not available or Update not available, an error has occurred during indexing that prevents you working with the index.

This command resets the index status so that you can continue to work with it. Before resetting the index status, check for any errors that may be logged in the index's log table (see Displaying error events).

Authorization

None.

Command syntax

>>-RESET INDEX STATUS--table-name------------------------------->
 
>-----+-----------------------------+--------------------------><
      '-HANDLE--handle-column-name--'
 

Command parameters

table-name
The name of the text table in the connected database that contains the text columns whose status is to be reset. The name must include an explicit schema name (qualifier) unless the schema name is the same as your user ID.

HANDLE handle-column-name
The name of the handle column whose status is to be reset.

Usage notes

For a multi-index table, you must specify a handle column name.

For a common-index table, each enabled column in this table is reset.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]