(a) Function

Sets the maximum number of retrieval items for the SQL statements to be executed.

(b) Format

 
public void setSQLOutNum ( int outNum ) throws SQLException
 

(c) Arguments

int outNum

Specifies the maximum number of retrieval items for 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 maximum number of retrieval items for the SQL statements to be executed.

This specification becomes the number of output items to be acquired during SQL preprocessing. The default value when this method is not called is 300.

If the actual number of output items is greater than the specification value of this method, the output item information is acquired after SQL preprocessing.

The value specified by this method becomes the value of the HiRDB_for_Java_SQL_OUT_NUM property, which is shown in 17.2.2(2) User properties.

(f) Exceptions

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

(g) Notes

When there are no retrieval items, you should specify 1 as the argument value.