MARS

Enable multiple active results sets when connecting to Microsoft SQL Server.

Syntax:

[NO]MARS

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 benefit in prefetching firehose cursors because the server streams the result set to the client for firehose cursors.