Before running , you must set the A_CONFIG environment variable to the name of the . You may want to make and use a personalized copy of the to avoid impacting other users. You could use the A_CONFIG environment variable to identify a personal . 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 variables that are specific to Database Connector for Oracle. 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 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 |