Enable multiple active results sets when connecting to an Microsoft SQL Server 2005 or later.
Dependencies:
To use this directive, you must also specify TARGETDB=MSSQLSERVER.
Scope:
| Used at compile time:
|
No
|
| Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comment:
For SQL Server connections, a forward-only read-only non-hold cursor always uses a firehose cursor with no prefetching. There is no beneft in prefetching firehose cursors because the server streams the result set to the client for firehose cursors.
