Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

ENABLE TEXT FILES

This command enables Text Extender to search in text files that are not in a DB2 UDB database.
Tip

This command cannot be used if the text columns in the table share a common index, as described in Enabling a text table.

Authorization

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

ALTER privilege

SELECT privilege

UPDATE privilege.

Command syntax

>>-ENABLE TEXT FILES--table-name---HANDLE--handle-column-name--->
 
>-----+-----------------------+--------------------------------->
      '-| text-information |--'
 
>-----+----------------------------+---------------------------->
      '-| index-characteristics |--'
 
>-----+----------------------------+---------------------------->
      '-UPDATEINDEX--+-UPDATE---+--'
                     '-NOUPDATE-'
 
>-----+------------------------------+-------------------------->
      '-TABLESPACE--tablespace-name--'
 
>-----+---------------------+----------------------------------><
      '-COMMITCOUNT--count--'
 
text-information
 
|---+---------------+---+---------------------+----------------->
    '-CCSID--ccsid--'   '-LANGUAGE--language--'
 
>-----+-----------------+---------------------------------------|
      '-FORMAT--format--'
 
index-characteristics
 
|---+-----------------------------------------------------------------+->
    '-INDEXTYPE--+-PRECISE----+---+--------------------------------+--'
                 +-LINGUISTIC-+   '-INDEXOPTION--+-CASE_ENABLED-+--'
                 +-DUAL-------+                  '-NORMALIZED---'
                 '-NGRAM------'
 
>----+--------------------------------------------------------------------------------+->
     |                                                          .-,------------.      |
     |                                                          V              |      |
     '-INDEXPROPERTY--SECTIONS_ENABLED--+-DOCUMENTMODEL--+---(-----modelname---+---)--'
                                        '-DOCUMENTMODELS-'
 
>----+----------------------------------------+----------------->
     '-UPDATEFREQ--+-NONE------------------+--'
                   '-| update-frequency |--'
 
>-----+-------------------------------------------------------------------------------+>
      +-DIRECTORY--directory----------------------------------------------------------+
      |  .--------------------------------------------------------------------------. |
      |  |                                          .-,---------------------.       | |
      |  V                                          V                       |       | |
      '----DIRECTORY--directory--ON--+-NODE--+---(-----node--+-----------+--+---)---+-'
                                     '-NODES-'               '-TO--node--'
 
>---------------------------------------------------------------|
 
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 is to be associated with the external text files to be indexed. The name must include an explicit schema name (qualifier) unless the schema name is the same as your user ID.

For a description of the other command parameters, see ENABLE TEXT COLUMN.

Usage notes

This command adds a handle column to the specified DB2 table. Each handle column is associated with a collection of external text files, and is used by Text Extender's UDFs. An index is created that is associated with these files.

After you have enabled the text files, initialize handles in the handle column using INIT_TEXT_HANDLE. Then fill the index using UPDATE INDEX.

You cannot reuse a handle column name if that name has been used before in ENABLE TEXT FILES to identify a handle column of a text column.

A log table is created for recording changes to the files, but you must activate the triggers manually to record these changes because DB2 UDB does not have the files under its control and is therefore not aware of such changes. See Updating an index for external files for a description of how to do this.

If you run out of log space in this step, see Enabling a text column in a large table for possible solutions.


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