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.