Nonstop Database, HiRDB Version 9 UAP Development Guide
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.
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.
java -D<name>=<value> class-name
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. |
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.
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
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.