OPTIMIZESPCURSORS

For SQL CLR stored procedures, opens forward read-only cursors as firehose cursors, and when subsequent cursors are opened, reads the remainder of the result set into memory to optimize performance.

Restriction: Applies to .NET applications only.

Syntax:

OPTIMIZESPCURSORS

Properties:

Default:

None

Dependencies:

To use OPTIMIZESPCURSORS, you must set DBMAN=ADO.

Scope:

Used at compile time:	Yes
Behavior at run time:	Source file

See Scope - OpenESQL SQL Compiler Directive Options and Scope - HCOSS SQL Compiler Directive Options for more information.

Comments:

Attempting to call a sub-program from a stored procedure with an open cursor is not supported if the OPTIMIZESPCURSORS directive is set.