IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

db2ext.textindexformats view

Format and model information for indexes is available in the db2ext.textindexformats view. This is an example using the index name:

db2 "select FORMAT from DB2EXT.TEXTINDEXFORMATS where INDSCHEMA='myschema' 
     and INDNAME='myindex'" 
 

Additional contents of the view are found in the following table.

Table 13. db2ext.textindexformats view

Attribute Type Notes
INDSCHEMA VARCHAR(128) Schema name for the index (used as prefix for indexname and schemaname in the log table).
INDNAME VARCHAR(128) Index name specified in CREATE INDEX command.
FORMAT VARCHAR(30) The model is bound to this format.
MODELNAME VARCHAR(30) The name of a document model.
MODELFILE VARCHAR(256) File containing the model definition.
MODELCCSID INTEGER CCSID of MODELFILE.
DEFAULT INTEGER Currently 1, as multiple formats in an index are not currently supported.


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