Environment Variables

Configuration Issues > Environment Variables

Depending on the operating system and the target RDBMS, some environment variables must be set. Some configurations also require that you add the appropriate paths to your environment. These considerations are described for the following RDBMSs:

DB2

The environment variables DB2DIR and DB2INSTANCE must be set.

Informix

UNIX® systems require the following variables:

INFORMIXDIR, which locates the Informix client installation.

INFORMIXSERVER, which provides the name of the default server.

DELIMIDENT=y, which must be defined if your application is to use delimited identifiers, because Rogue Wave DB Link libraries are compiled with this variable.

If you use shared libraries, add $INFORMIXDIR/lib and $INFORMIXDIR/lib/esql to the appropriate path variable (PATH or LD_LIBRARY_PATH or SHLIB_PATH).

On PCs, the use of the Informix Utility setnet32 sets all necessary variables in the registry.

MS SQL Server

All needed information is set in the registry upon installation.

Oracle

On UNIX systems, the environment variable ORACLE_HOME must be set. If you use shared libraries, add $ORACLE_HOME/lib32 if running in 32bits, or $ORACLE_HOME/lib if runnning 64bits,to the shared libraries path variable.

On PCs, the variable ORACLE_HOME and numerous other values are set in the registry upon installation, and %ORACLE_HOME%\bin is added to the PATH variable.

Version 5.8