Nonstop Database, HiRDB Version 9 UAP Development Guide
This section shows search examples in which the file output facility for BLOB data is used.
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.
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.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.