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 ODBC connections. 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 then:
| Variable | Description |
|---|---|
| A_ODBC_ALTERNATE_COMMT_LOGIC | Determines how the connection responds to transaction requests |
| A_ODBC_CATALOG | Specifies the catalog in use for the connection |
| A_ODBC_COMMIT_ON_BEGIN | Marks the start of a transaction |
| A_ODBC_DATASOURCE | Determines the name of the datasource you connect to |
| A_ODBC_ERROR_MAP_FILE | Enables the use of a map file that maps database errors to your COBOL error codes |
| A_ODBC_ISOLATION_LEVEL | Determines the isolation level of the connection |
| A_ODBC_LOCK_METHOD | Determines the locking method for the connection |
| A_ODBC_LOGIN | Login details for the associated database |
| A_ODBC_NO_NULL_COLUMNS | Determines if NULL is permitted to be inserted into a database |
| A_ODBC_PASSWD | Login details for the associated database |
| A_ODBC_PRINT_LOG | Debugging variable; do not use unless instructed to |
| A_ODBC_QUOTE_IDENTIFIERS | Tests for the IDENTIFIER-QUOTE-CHAR, and if found, uses it |
| A_ODBC_STRICT_EQUAL | A performance enhancing variable that makes SELECT statements more efficient |
| A_ODBC_TABLE_TYPES | A performance enhancing variable that enables you to defines the type of table to search for |
| A_ODBC_UNSIGNED_TINYINT | Overrides driver behavior when a TINYINT data type is assigned to an internal unsigned type |
| A_ODBC_USE_CATALOG | Enables the use of a catalog in SQL queries |
| A_ODBC_USE_CHAR_FOR_BINARY | Allows you to store data that uses the BINARY directive as hexadecimal encoded CHAR types |
| A_ODBC_USE_SPACE_IN_DATES | Allows the use of spaces in dates |
| A_ODBC_USE_SQLCOLUMNS | Uses the SQLColumns() API function to call SQLDescribeCol(). This is a useful time-saving task for large databases. |
| A_ODBC_USE_SQLTABLES | Builds a test SQL query and uses the SQLTables() API function to call SQLNumResultCols() to determine if a table exists. This is a useful time-saving task for large databases. |