If you set the HiRDB_for_Java_BLOCK_UPDATE system property during program execution, you can specify whether or not to process multiple parameter sets at one time during database updating using the ? parameter (INSERT, UPDATE, or DELETE).

During program execution, use the -D option of the java command to set the HiRDB_for_Java_BLOCK_UPDATE system property.

(a) Function

This function sets whether or not multiple parameter sets are to be processed at one time during database updating using the ? parameter (INSERT, UPDATE, or DELETE).

(b) Format

 
java -D<name>=<value> class-name
 

(c) Description

name

HiRDB_for_Java_BLOCK_UPDATE

value

TRUE: Processes multiple parameter sets at one time.

FALSE: Processes one parameter set at a time.

Other: Processes one parameter set at a time.

(d) Functional detail

This function sets whether or not multiple parameter sets are to be processed at one time during database updating using the ? parameter.

Whether or not the parameter sets are actually processed at one time depends on the method for using the facilities using arrays. For details about how to use the facilities using arrays, see 4.8 Facilities using arrays.

(e) Notes

• When you specify -D<name>=<value>, make sure that there is no space in the specified information. The specified information cannot be set correctly if it has any of the following formats, where indicates a space:
  
  • -D<name>=<value>
  • -D<name>=<value>
  • -D<name>=<value>
• If BLOCK_UPDATE is set during database connection (setBlockUpdate method during data source connection), BLOCK_UPDATE or the value set in the setBlockUpdate method takes effect.
• If you used the PreparedStatement class's setBlockUpdate method, you can change the setting as to whether or not multiple parameter sets are to be processed at one time.
• For details about how to process multiple lines of ? parameters in batch mode, see Table 16-3 Information to be specified for Properties info and 16.3.2 Batch updating.

(f) Example

The following shows an example of setting the HiRDB_for_Java_BLOCK_UPDATE system property:

 
java -DHiRDB_for_Java_BLOCK_UPDATE=TRUE TestUP