Sets the AUTOFETCH attribute on SELECT statements that are run on Microsoft SQL Server data sources. Compiling with this directive
can help the performance of your application. This directive works only if the program is also compiled with directive SQL(TARGETDB=MSSQLSERVER).
It also serves as a primitive directive for the BEHAVIOR directive option.
- Errors on a cursor OPEN are deferred until the subsequent FETCH when AUTOFETCH is enabled.
- BEHAVIOR=OPTIMIZED for MS SQL Server enables AUTOFETCH
- Errors on a cursor OPEN are deferred until the subsequent FETCH when AUTOFETCH is enabled
|Used at compile time:
|Behavior at run time:
Scope - OpenESQL SQL Compiler Directive Options for more information.