Examples of using the file output facility for BLOB data

Scalable Database Server, HiRDB Version 8 UAP Development Guide

4.13.5 Examples of using the file output facility for BLOB data

This section shows search examples in which the file output facility for BLOB data is used.

Organization of this subsection: (1) Retrieving BLOB columns; (2) Retrieving an abstract data type that has the BLOB attribute

(1) Retrieving BLOB columns

In the following example, columns C1 and C2 are searched from table T1. The BLOB data in column C1 is output to files, and the names of those files are obtained.

[Figure]

(2) Retrieving an abstract data type that has the BLOB attribute

In the following example, the ADT1 column in which CONTAINS() is true is searched from table T2. At this time, the BLOB values of the results for passing the columns values to the EXTRACTS() argument are output to a file, and the file name is obtained. This example shows the case when all values are hit.

[Figure]