Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

DISABLE TEXT TABLE

This command disables all the text columns in a table for use by Text Extender.

Authorization

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

ALTER privilege

SELECT privilege

UPDATE privilege.

Command syntax

>>-DISABLE TEXT TABLE--table-name------------------------------><
 

Command parameters

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

Usage notes

This command makes all the text columns in the table unusable by Text Extender.

If the text columns in this table were enabled individually by ENABLE TEXT COLUMN, it deletes all their associated text indexes. (To disable text columns and delete their associated text indexes individually, use the DISABLE TEXT COLUMN command.) If the text columns in this table were enabled together by ENABLE TEXT TABLE, there is one common index for all the text columns. This command deletes the common index.

The log tables used to record changes in the text columns (inserts, updates, and deletions) are deleted. The triggers that write entries to the log table are deleted.


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