Programming Guide

Sets the maximum number of rows in a select set

#include <dmuproto.h>

int dm_set_max_fetches(int count);

count

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

• The new maximum number of rows. If count is -1, the current value.

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.

dm_set_max_rows_per_fetch

---

---