Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

4.14.1 What is the addition update and partial extraction facility for BLOB and BINARY data?

If all registered BLOB or BINARY* data must be updated when new data is added, or if all BLOB or BINARY* data must be fetched when data is retrieved, both the server and client must secure large amounts of memory that match the enormous data size. Consequently, the memory resources become used up. The addition update and partial extraction facility for BLOB and BINARY data is used for solving this problem.

* This refers to BINARY data that has a minimum defined length of 32,001 bytes.
Organization of this subsection
(1) Addition update of BLOB or BINARY data
(2) Partial extraction of BLOB or BINARY data

(1) Addition update of BLOB or BINARY data

To add new data to registered BLOB or BINARY data, specify a concatenation operation in the SET clause of the UPDATE statement. The amount of memory used is suppressed to the amount of data to be added.

(2) Partial extraction of BLOB or BINARY data

To extract only the specified portion from BLOB or BINARY data, specify the SUBSTR scalar function. The amount of memory used is suppressed to the amount of data to be extracted.