Using Environment Variables in Database Path Names

You can use environment variables in the specification of the database path name and transaction log file path name.

For example, you can specify $HOME/AdminDS for the location of the database.

Environment variables can be expressed either as $varname or $(varname). The parentheses are optional. A backslash character (\) in the database path name quotes the next character.

Note:

Environment variable expansion uses the environment of the process connecting to the database. Different processes may have different values for the same environment variables and may therefore expand the database path name differently. Environment variables can only be used in the user odbc.ini file. They cannot be specified in the system sys.odbc.ini file.