Previous Topic Next topic Print topic

Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > OpenESQL > SQL Compiler Directive Options > OPTIMIZESPCURSORS

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 for more information.

Parent topic: SQL Compiler Directive Options
Previous Topic Next topic Print topic