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 ACUFH configuration file variables that are specific to Database Connector for Oracle. 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, go to 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.
| 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_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 |