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:
Windows:
SET A_CONFIG=directory-name\my-file-name
UNIX:
A_CONFIG=directory-name/my-file-name export A_CONFIG
ensures the specified configuration file is used when interfacing with your database.
This section lists the ACUFH configuration file variables that are specific to DB2. 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.
| Variable | Description |
|---|---|
| A_DB2_ALTERNATE_COMMIT_LOGIC | Determines how the interface responds to the setting of 4GL_COMMIT_COUNT |
| A_DB2_CATALOG | Indicates the catalog name to be used when the Connector searches for objects in the database |
| A_DB2_COMMIT_ON_BEGIN | To ensure that the previous transaction has been ended before a new one begins, set A_DB2_COMMIT_ON_BEGIN to a nonzero value |
| A_DB2_DATASOURCE | Set to the exact name of the host data source |
| A_DB2_ERROR_MAP_FILE | Allows you to map errors using a text file to supplement the default method of providing errors |
| A_DB2_ISOLATION_LEVEL | Sets the isolation level |
| A_DB2_LOCK_METHOD | Specifies the locking method that the Connector should use when accessing your data source |
| A_DB2_LOGIN | Indicates the user name under which you want to connect to the database system |
| A_DB2_PASSWD | Set to the password assigned to the database account associated with the user name specified by A_DB2_LOGIN |
| A_DB2_STRICT_EQUAL | Causes the interface to stop fetching data when it reaches the end of data specified by a SELECT statement |
| A_DB2_TABLE_TYPES | Specifies a table type that should be looked for when selecting a database table |
| A_DB2_USE_CATALOG | Enables you to use the catalog in the actual SQL queries |
| A_DB2_USE_CHAR_FOR_BINARY | Lets you store data that uses the BINARY XFD directive as hexadecimal encoded CHAR types |
| A_DB2_USE_SQLCOLUMNS | Causes the API function call SQLDescribeCol() to be used instead of SQLColumns() |
| A_DB2_USE_SQLTABLES | Builds a test SQL query and uses the API function call SQLNumResultTables() to determine if a table exists |
| USER_PATH | Indicates the user name or names (schemas) to be used when the Connector searches for files |