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:
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 Oracle. 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_ORA_DATABASE | Specifies the name of a network service that you have set up to refer to a database |
| A_ORA_HINTS | Enables the Oracle Hints feature |
| A_ORA_KEEP_START_CURSOR | Key value is saved for subsequent READ NEXT/PREVIOUS operations |
| A_ORA_LIMIT_DROPDOWN | Improve performance when the interface generates a sequence of DROP DOWN queries |
| A_ORA_MAX_FILE_CURSORS | Allows you to set the maximum number of cursors that the run time system is allowed to have per file |
| A_ORA_NLS_SORT | Forces the sort order of returned records to be in a binary order |
| A_ORA_WAIT_LOCK | Determines the type of Oracle locks used: wait or nowait |
| A_ORACLE_ERROR_FILE | Allows you to map errors using a text file to supplement the default method of providing errors |
| COMMIT_COUNT | Indicates the conditions under which you want to issue an automatic COMMIT_WORK operation |
| ORA_LOGIN | Indicates the user name under which you want to connect to the database system |
| ORA_PASSWD | Set to the password assigned to the database account associated with the user name specified by ORA_LOGIN |
| USER_PATH | Indicates the user name or names to be used when the Connector searches for files |