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. You could use the A_CONFIG environment variable to identify a personal ACUFH configuration file. For example:
SET A_CONFIG=directory name\file name
defines a configuration file with the name of your choice in the directory of your choice.
This section lists the run time configuration file variables that are specific to Database Connectors for DB2. ACUFH configuration file variables that are generally applicable to any RDBMS with which the Connector communicates are discussed in the section ACUFH Configuration Variables in the chapter Runtime Configuration. For detailed descriptions of these variables, see the Reference > Configuration Variables section of your Database Connectors documentation.
For information on dynamic redirection to a custom file handler, see the section Enabling Dynamic Redirection to a Custom File Handler.
To create a sample COBOL application, see the section Creating a COBOL Application.
| 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_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 |