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.
Note:
- 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
Scope:
Used at compile time:
|
No
|
Behavior at run time:
|
Source file
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.