Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

CHANGE INDEX SETTINGS

This command changes the characteristics of an index after the database has been enabled.

To changes the default settings that are used when a database is first enabled, use CHANGE TEXT CONFIGURATION.

Authorization

You must have at least one of the following for the table:

ALTER privilege

SELECT privilege

UPDATE privilege.

Command syntax

>>-CHANGE INDEX SETTINGS--table-name---------------------------->
 
>-----+-----------------------------+--------------------------->
      '-HANDLE--handle-column-name--'
 
>-----+----------------------------------------+---------------><
      '-UPDATEFREQ--+-NONE------------------+--'
                    '-| update-frequency |--'
 
update-frequency
 
|---MIN--(--mindocs--)--D---(--+-*------------+---)---H--------->
                               |  .-,-------. |
                               |  V         | |
                               '----0...6---+-'
 
                                       .-,---------.
                                       V           |
>----(--+-*-------------+---)---M---(-----0...59---+---)--------|
        |  .-,--------. |
        |  V          | |
        '----0...23---+-'
 

Command parameters

table-name
The name of the text table in the connected database that contains the text column whose index update frequency is to be changed. 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 index update frequency is to be changed. This is required if the text column has its own index, that is, if the index was created using the command ENABLE TEXT COLUMN.

If, however, the index was created using the command ENABLE TEXT TABLE, that is, the table has one text index for all text columns, then this keyword is ignored.

UPDATEFREQ

update-frequency

The index update frequency in terms of when the update is to be made, and the minimum number of text documents that must be queued in the log table. If there are not enough text documents in the log table at the day and time given, the index is not updated.

The syntax is described in Setting the frequency of index updates.

NONE
No further index updates are made. This is intended for a text column in which there will be no further changes.

If you do not specify the UPDATEFREQ keyword, the frequency settings are left unchanged.


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