ACUFH Configuration File Variables for ODBC

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

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.