Before running Database Connectors, you must set the A_CONFIG environment variable to the name of the ACUFH configuration file. You may want to make and use a personalized copy of the ACUFH configuration file to avoid impacting other users. Set the A_CONFIG environment variable to identify your own personal copy. For example:
SET A_CONFIG=directory-name\my-file-name
ensures the specified configuration file is used when interfacing with your database.
This section lists the ACUFH configuration file variables that are specific to MSSQL. For ACUFH configuration file variables that are generally applicable to any RDBMS with which Database Connectors communicates, see ACUFH Configuration Variables in the Run Time Configuration section.
As a minimum, you should set the following configuration variables:
and either:
or:
| Variable | Description |
|---|---|
| A_MSSQL_ADD_IDENTITY | Adds an extra column to any table created by the Connector |
| A_MSSQL_ADD_TIMESTAMP | Ensures that modifications made to a row are not overwriting someone else's changes |
| A_MSSQL_APPROLE_NAME | Allows the Connector to use approles |
| A_MSSQL_APPROLE_PASSWD | Allows the Connector to use approles |
| A_MSSQL_CREATE_UNICODE_COLUMNS | Creates nchar or nvarchar columns for all new text data |
| A_MSSQL_CURSOR_OPTION_1, | Allow you to fine-tune the declaration of cursors in the Connector |
| A_MSSQL_DATABASE | Specifies the name of the particular database to be accessed |
| A_MSSQL_DEADLOCK_LOOPS | Can be used to instruct the Connector to re-execute an INSERT statement |
| A_MSSQL_DEFAULT_CONNECTION | Specifies the name of the server to which the run time system connects |
| A_MSSQL_DEFAULT_OWNER | Specifies the name of the user of a table |
| A_MSSQL_DO_NOT_TRANSLATE_CHAR | Enables all character fields (except date fields) to be treated as binary, instead of being translated |
| A_MSSQL_FAILOVER_PARTNER | Specifies the name of the failover partner used when multi-subnet failover support is enabled |
| A_MSSQL_FAILOVER_PARTNER_SPN | Specifies the name of the failover partner SPN used when multi-subnet failover support is enabled |
| A_MSSQL_FAST_ACCESS | Files opened while this variable is set to a nonzero value are optimized for forward sequential access |
| A MSSQL IGNORE GUID COLUMNS | Enables you to ignore columns of type GUID |
| A_MSSQL_LIMIT_DROPDOWN | This variable allows an application to direct the interface not to perform "drop down" query generation and instead return "end of file" when the records matching the current query have been exhausted. |
| A_MSSQL_LOCK_DB | Specifies the name of the database that holds the lock table |
| A_MSSQL_LOGIN | Indicates the user name under which you want to connect to the database system |
| A_MSSQL_MAX_BINARY_LENGTH | Specifies the maximum size of a COBOL variable that can be used as a BINARY data type |
| A_MSSQL_MAX_CHAR_LENGTH | Specifies the maximum size of a COBOL variable that can be used as a VARCHAR data type |
| A_MSSQL_MAX_CHARACTERS | Indicates the maximum number of bytes the Connector allows in a table row |
| A_MSSQL_MAX_COLUMNS | Indicates the maximum number of columns the Connector allows in a table |
| A_MSSQL_MULTI_SUBNET_FAILOVER | Set to TRUE to enable multi-subnet failover support for your Microsoft SQL Server connection |
| A_MSSQL_NATIVE LOCK_TIMEOUT | Enables the native locking method (as opposed to the AcuLocks1 table being used to hold locks). |
| A_MSSQL_NO_CACHED_READ | Determines if the 'cached-read' method, which can improve performance, is in effect |
| A_MSSQL_NO_COUNT_CHECK | Causes the interface not to check that a record was updated |
| A_MSSQL_NO_DBID | Causes the interface to use a Database ID of "0", instead of the actual ID of the database |
| A_MSSQL_NO_RECORD_LOCKS | Causes all READS to be treated as READ NO LOCK |
| A_MSSQL_NO_TABLE_LOCKS | Causes the interface to not use the AcuOpenTables1 table, which causes all table locking to be disabled |
| A_MSSQL_NO_23_ON_START | Causes START not to detect whether records actually exist |
| A_MSSQL_NT_AUTHENTICATION | Indicates whether MSSQL authenticates users based on their Windows login |
| A_MSSQL_ODBC_DRIVER_NAME | Specifies the ODBC SQL Server driver name for the SQL Server interface |
| A_MSSQL_PACKETSIZE | Sets the size of network packets |
| A_MSSQL_PASSWD | Set to the password assigned to the database account associated with the user name specified by A_MSSQL_LOGIN |
| A_MSSQL_ROWCOUNT | Determines how many rows are returned by a SELECT statement sent to the server |
| A_MSSQL_SELECT_KEY_ONLY | Directs the interface to select key columns only when searching for records |
| A_MSSQL_SEPARATE_LOCK_CONN | Determines whether a separate connect is made to handle the internal workings |
| A_MSSQL_SERVER_SPN | Specifies the name of the server SPN used when multi-subnet failover support is enabled |
| A_MSSQL_SKIP_ALTERNATE_KEYS | Determines whether alternate keys are used to form indexes during table creation |
| A_MSSQL_STRIP_PATH_INFO | Strips the Servername portion from the MSSQL naming syntax |
| A_MSSQL_TRANSACTION_LEVEL | Indicate the transaction nested level depth |
| A_MSSQL_TRANSLATE_TO_ANSI | Causes the Connector to call the same translation function used by the Windows run time system to translate characters going to the server into the OEM character set, and to translate characters coming from the server to ANSI |
| A_MSSQL_UNLOCK_ON_EXECUTE | Causes all invocations of I$IO using the EXECUTE opcode to unlock all records |
| A_MSSQL_UPDATE_PRIMARY_COLS | Updates all the fields in a table in files that have only primary key fields |
| A_MSSQL_USE_DROPDOWN_QUERIES | Causes selects sent to the database to be of the drop-down variety, instead of a single large query |