A_MSSQL_CURSOR_OPTION_1 A_MSSQL_CURSOR_OPTION_2 A_MSSQL_CURSOR_OPTION_3
These ACUFH configuration file variables allow you to fine-tune the declaration of cursors. In general, cursors are declared with the following syntax:
DECLARE cursor_name option_1 CURSOR option_2 FOR <select....> option_3
In other words, different phrases can go in each of the option_X places. Also, different versions of Microsoft SQL Server allow different options in each of those places. Because of this, Database Connectors allows customization of the cursor declaration via these three variables. The values of these variables are placed verbatim into the declare phrase when building a cursor. Note that any errors in the values of these variables may cause Database Connectors to be inoperable. Be sure to read the Microsoft SQL Server documentation to determine what phrases are allowed in each case.
The default values are as follows (the limit is 65 characters for each option):
OPTION_1: | "SCROLL" |
OPTION_2: | blank |
OPTION_3: | "For read only" |