Maximum Rows - 6.4.3.0


If necessary, specifies a limit to the number of rows you want returned by the SQL/Stored Procedure statement. This value overrides any value you specify in the database connection.

(A default limit can be specified by the SQL/Stored Procedure Maximum Rows Universal Controller system property.)

If you set Maximum Rows to 0, no content from any of the ResultSets will be retrieved (the next() method on ResultSet will not be called). Each ResultSet will be closed, but no data or rows accessed.