Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Excalibur Text Search DataBlade® Module User's GuideThese topics describe the module and how to access and use its components.
TutorialThis section provides a step-by-step procedure for setting up and performing text searches by using the module.
Create an etx indexTo create an etx index, you specify the etx access method in the USING clause of the CREATE INDEX statement. You specify the operator class right after specifying the indexed column.
Create an etx indexThis section describes how to create fragmented and nonfragmented indexes.
Create an index on a filtered columnWhen you create an index with the CREATE INDEX statement, you can set the FILTER index parameter to specify that you want to filter formatting information from the documents before they are added to the etx index.

Create an index on a filtered column

When you create an index with the CREATE INDEX statement, you can set the FILTER index parameter to specify that you want to filter formatting information from the documents before they are added to the etx index.

The following statement creates an etx index on the abstract column of the my_table table and specifies that the documents in the abstract column should be filtered before they are added to the index:

CREATE INDEX abstract_index ON my_table (abstract etx_clob_ops)
    USING etx (FILTER = 'STOP_ON_ERROR');

You can enable filtering on columns of all seven data types supported by the module: CHAR, VARCHAR, BLOB, CLOB, LVARCHAR, IfxDocDesc, and IfxMRData.

The FILTER index parameter can be set to three values: NONE (the default value), STOP_ON_ERROR, or CONTINUE_ON_ERROR.