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.
Data typesThis section describes the data types that come with the module.
The etx_HiliteType data type

The etx_HiliteType data type

The data type etx_HiliteType is a named row type defined by the module as follows:

CREATE ROW TYPE etx_HiliteType
(
   vec_offset CLOB,
   viewer_doc BLOB
);

The etx_HiliteType data type is the data type of the information returned by the etx_GetHilite() and etx_HiliteDoc() routines. These routines are used to highlight the location of a clue in a document. The following example shows how to use the etx_GetHilite() function in a SELECT statement:

SELECT etx_GetHilite (description, rc) FROM videos
    WHERE etx_contains(description, 
    'multimedia',  rc # etx_ReturnType);

In the example, rc is the statement local variable (SLV) passed to the function etx_GetHilite().

Highlighting information is broken up into two parts: offset information about the location of the clue in a document and the document itself. The offset information is contained in the vec_offset field of the etx_HiliteType data type and the document is contained in the viewer_doc field.