Turns off multi-row fetches across the network.
{ DisableMultiRowFetch | DMRF }={ YES | NO }
Anywhere
NO
By default, when the database server gets a simple fetch request, the application asks for extra rows. You can disable this behavior by setting this parameter to YES. See Cursors in procedures, triggers, user-defined functions, and batches.
Setting the DisableMultiRowFetch (DMRF) connection parameter to YES is equivalent to setting the prefetch database option to Off. See Prefetches.
The following connection string fragment prevents prefetching:
DMRF=YES
Syntax