Programming Guide


Sets the maximum number of rows in a select set

#include <dmuproto.h>
int dm_set_max_fetches(int count);

Maximum number of rows to be in the select set. If -1, return the current setting.



dm_set_max_fetches determines the maximum number of rows that will be retrieved from a SELECT statement or DBMS CONTINUE command. If -1 is passed in as the value, the function returns the current value; otherwise, it returns the new maximum value.

Initially, the maximum number of fetches is determined by the default value of the max_fetches application property, which is 1,000. This property provides an alternative way to modify the maximum number of fetches.

See Also