(a) Function

Sets the maximum number of input ? parameters in the SQL statements to be executed.

(b) Format

 
public void setSQLInNum ( int inNum ) throws SQLException
 

(c) Arguments

int inNum

Specifies the maximum number of input ? parameters in the SQL statements to be executed. The specification value range is from 1 to 30,000.

(d) Return value

None.

(e) Functional detail

Sets the number of input ? parameter information items to be retrieved during SQL preprocessing.

If the actual number of ? parameters is greater than the specification value of this method, the input ? parameter information is retrieved after SQL preprocessing. The default value when this method is not called is 300.

At the time of database connection, the value specified by this method becomes the value of the HiRDB_for_Java_SQL_IN_NUM property, which is shown in 17.2.2(2) User properties.

(f) Exceptions

If a value outside the range from 1 to 30,000 is specified in the argument, this method throws an SQLException.

(g) Notes

If the application does not execute SQL statements that have input ? parameters, you should specify 1 as the argument value.