(a) Function

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

(b) Format

 
public void setSQLOutNum(int outNum)
 

(c) Argument

int outNum

Specifies the maximum number of search items, output ? parameters, 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 search items, output ? parameters, or input/output ? parameters in the SQL statements to be executed.

This specification is used as the number of output items that are to be acquired during SQL preprocessing.

If the number of actual output items is greater than the value of this property, the method acquires information about the output items after SQL preprocessing.

The value specified in this method is used as the value of the HiRDB_for_Java_SQL_OUT_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_OUT_NUM system property. If the setSQLOutNum method has been set, the HiRDB_for_Java_SQL_OUT_NUM system property setting is ignored.
• If there is no search item, output ? parameter, or input/output ? parameter, we recommend that you specify a value of 1.