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.
OverviewThis section provides an overview of the module.
Components of the Excalibur Text Search DataBlade® moduleThe module has three principal components: the etx access method, the etx_contains() operator, and the supporting routines defined for the DataBlade® module.
Routines defined for the DataBlade® moduleIn addition to the etx_contains() operator, the module includes several routines that you can use to perform tasks, such as creating and dropping synonym and stopword lists.

Routines defined for the DataBlade module

In addition to the etx_contains() operator, the module includes several routines that you can use to perform tasks, such as creating and dropping synonym and stopword lists.

An example of one of these routines is etx_CreateSynWlst(). This routine allows you to create a list of words that you want the search engine to treat as synonyms. To use this procedure to create a synonym list, you use the EXECUTE PROCEDURE statement as shown in the following example:

EXECUTE PROCEDURE etx_CreateSynWlst
    ('syn_list', '/local0/excal/synonyms','sbsp1');

This statement creates a synonym list named syn_list from an operating system file called /local0/excal/synonyms and stores it in the sbspace called sbsp1.