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 IfxMRData data typeThe IfxMRData data type is a multirepresentational opaque type, defined in the HCL OneDB™ Text Descriptor DataBlade® Module for use with the . It provides for fast and efficient storage of ASCII text data.
Populate a table that contains an IfxMRData columnThere are two ways to enter data into a column of type IfxMRData: either by specifying a string in the INSERT statement or by reading the data from an operating system file.

Populate a table that contains an IfxMRData column

There are two ways to enter data into a column of type IfxMRData: either by specifying a string in the INSERT statement or by reading the data from an operating system file.

Suppose that some of your search text is stored in the following collection of files on the UNIX™ file system:

/local0/excal/desc1.txt
/local0/excal/desc2.txt

Further suppose that you want to enter data into a table called videos2, described by the following example:

CREATE TABLE videos2
(
    id           INTEGER,
    name         VARCHAR(30),
    description  IfxMRData
);

The next sections show how the IfxMRData behaves when you insert data into this example table.