Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Reversing the text preparation process

When text is prepared for use by Text Extender, certain administrative changes are made. This section describes functions that help you to reverse this process.

Disabling a text column

Summary

When
When you no longer intend to make text searches in a text column.

Command
DISABLE TEXT COLUMN

Authorization
ALTER, SELECT, UPDATE on the table

Example:

     db2tx "DISABLE TEXT COLUMN db2tx.sample
                                HANDLE commenthandle"

When you disable a text column, the following occurs:

Disabling text files

Summary

When
When you no longer intend to make text searches in a set of external text files.

Command
DISABLE TEXT FILES

Authorization
ALTER, SELECT, UPDATE on the table

Example:

     db2tx "DISABLE TEXT FILES db2tx.sample
                                HANDLE commenthandle"

When you disable external text files, the following occurs:

Disabling a text table

Summary

When
When you no longer intend to make text searches in a text table.

Command
DISABLE TEXT TABLE

Authorization
ALTER, SELECT, UPDATE on the table

Example:

     db2tx "DISABLE TEXT TABLE db2tx.sample"

When you disable a text table, the following occurs:

Disabling a database

Summary

When
When you no longer intend to make text searches in this database.

Command
DISABLE DATABASE

Authorization
SYSADM or DBADM on the database

To disable the connected database , enter:

     db2tx "DISABLE DATABASE"

When you disable a database, the following objects are deleted:

Because handle columns cannot be deleted, and the handle column is of a distinct type, some distinct types are not deleted.


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