(a) Function

Specifies the maximum number of input or input/output ? parameters in the SQL statements to be executed.

(b) Format

 
public void setSQLInNum(int inNum)
 

(c) Argument

int inNum:

Specifies the maximum number of input or input/output ? parameters in the SQL statements to be executed. The permitted value range is from 1 to 30,000 (default is 64).

(d) Return value

None.

(e) Functional detail

Specifies the maximum number of input or input/output ? parameters to be acquired during SQL preprocessing.

If the actual number of ? parameters is greater than this property value, this method acquires information about the input or input/output ? parameters after SQL preprocessing.

The value specified in this method is used as the value of HiRDB_for_Java_SQL_IN_NUM property during database connection.

(f) Exception that occurs

If the specified argument value falls beyond the permitted range, the method throws an SQLException.

(g) Notes

• This function can also be specified by the HiRDB_for_Java_SQL_IN_NUM system property. If the setSQLInNum method has been set, the HiRDB_for_Java_SQL_IN_NUM system property setting is ignored.
• If you do not execute any SQL statement that uses input or input/output ? parameters, we recommend that you specify a value of 1.