When you use the addition update and partial extraction facility for BLOB and BINARY data, note the following points:

1. A concatenation operation for BLOB or BINARY data can be specified only with an update value in the SET clause of the UPDATE statement. The item specified for the first term in the concatenation operation must be a column specification, and the item specified for the second term must be an embedded variable, the ? parameter, an SQL variable, or an SQL parameter.
   For details about the rules for using the concatenation operation to update a BLOB-type or BINARY-type column, see the manual HiRDB Version 8 SQL Reference.
   
2. To execute an addition update, create a column that stores unique key values, and specify that column in the search conditions to identify the update row. To accelerate the row identification process, create an index in that column.
3. The minimum input/output unit for BLOB data is the page length of the RDAREA, and HiRDB performs batch input/output of up to 128 kilobytes. Therefore, to improve the performance of BLOB data insertion, addition update, or partial extraction, you should set the data length to units of 128 1024 n bytes (n is a nonzero positive integer).
4. The BINARY data described in this subsection refers to BINARY data with a minimum defined length of 32,001 bytes.