If you set the HiRDB_for_Java_SQL_IN_NUM or HiRDB_for_Java_SQL_OUT_NUM system property during program execution, you can specify the maximum number of search items, output ? parameters, input ? parameters, or input/output ? parameters that are to be acquired during SQL preprocessing.

During program execution, set the system property HiRDB_for_Java_SQL_OUT_NUM or HiRDB_for_Java_SQL_IN_NUM or both in the -D option of the java command.

(a) Function

This function specifies the maximum number of search items, output ? parameters, input ? parameters, or input/output ? parameters that are to be acquired during SQL preprocessing.

(b) Format

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

(c) Description

The following table describes the information that can be specified in <name> and <value>:

<name>	<value>
HiRDB_for_Java_SQL_IN_NUM	Specifies the maximum number of input or input/output ? parameters in the SQL statements to be executed. This is the number of input or input/output ? parameter information items acquired during SQL preprocessing. If the actual number of input or input/output ? parameters is greater than this property value, the input or input/output ? parameter information is acquired after the SQL preprocessing. The permitted value range is from 1 to 30,000 (default is 64). Specifying any other value or a non-numeric value results in an error during database connection.
HiRDB_for_Java_SQL_OUT_NUM	Specifies the maximum number of output items for the SQL statement to be executed. This is the number of output items acquired during SQL preprocessing. If the actual number of output items is greater than this property value, the output items are acquired after the SQL preprocessing. The permitted value range is from 1 to 30,000 (default is 64). Specifying any other value or a non-numeric value results in an error during database connection.

(d) Functional detail

This function specifies the maximum number of search items, output ? parameters, input ? parameters, or input/output ? parameters that are to be acquired during SQL preprocessing. A sufficient value enables you to acquire search item, output ? parameter, input ? parameter, or input/output parameter information during SQL preprocessing, thereby improving performance compared to when this information is acquired after preprocessing.

(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 HiRDB_for_Java_SQL_IN_NUM is set during database connection (setSQLInNum method during data source connection), HiRDB_for_Java_SQL_IN_NUM or the value set in the setSQLInNum method takes effect.
• If HiRDB_for_Java_SQL_OUT_NUM is set during database connection (setSQLOutNum method during data source connection), HiRDB_for_Java_SQL_OUT_NUM or the value set in the setSQLOutNum method takes effect.
• To acquire search item, output ? parameter, input ? parameter, or input/output parameter information during SQL preprocessing, the version of the connected HiRDB server must be 07-02 or later.

(f) Example

The following shows an example of setting the HiRDB_for_Java_SQL_IN_NUM and HiRDB_for_Java_SQL_OUT_NUM system properties:

 
java -DHiRDB_for_Java_SQL_IN_NUM=128 -DHiRDB_for_Java_SQL_OUT_NUM=128 TestUP