Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

DISABLE TEXT COLUMN

This command disables a text column 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 COLUMN--table-name--HANDLE--handle-column-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.

HANDLE handle-column-name
The name of the handle column to be disabled for use by Text Extender.

Usage notes

The index is deleted.

The log table used to record changes in the handle column (inserts, updates, and deletions) is deleted.

The triggers that write entries to the log table are deleted.

The handle column is not changed.


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