Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

ENABLE DATABASE

This command enables the current database to store text data.

Authorization

You must have:

SYSADM authority

DBADM authority.

Command syntax

>>-ENABLE DATABASE---------------------------------------------><
 

Command parameters

None.

Usage notes

You must be connected to a database , either explicitly or implicitly, before issuing this command (see CONNECT). This command prepares the connected database for use by Text Extender. It is a mandatory step before a Text Extender text table or text column can be enabled in the database .

ENABLE DATABASE creates a Text Extender catalog view called DB2TX.TEXTINDEXES, described in Working with the Text Extender catalog view, and a catalog view called DB2TX.TEXTCOLUMNS used for "performance" queries.

It also creates text configuration settings, described in Text configuration settings.

Some other administration work is also done, such as the declaration of UDTs and UDFs.


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