Setting Environment Variables

You must properly define all compiler-specific and database-specific environment variables and system settings before building the DB Interface Module libraries.

Table 30 lists an environment variable for each of the DB Interface Module access libraries and describes the typical settings required. The rest of this section provides operating system-specific instructions for setting the variables.

Table 30. Environment variables

Database

Variable Name

Notes

Microsoft SQL Server

n/a

For the SQL Server Native Client driver, RCB includes a field to specify the path to the driver installation directory. For the SQL Server driver, the compiler's default settings take care of this.

MySQL

n/a

RCB includes a field to specify the path to the MySQL installation.

DB2 CLI

DB2DIR

Set the variable to the path in which DB2 CLI is installed.

ODBC

ODBC

UNIX: Set the variable to the path in which the ODBC library and header files are installed.
Microsoft: Do not set this variable. Your compiler’s default settings take care of this for you.

Oracle OCI

ORACLE_HOME

Set the variable to the path in which Oracle is installed.

PostgreSQL

n/a

RCB includes a field to specify the path to the PostgreSQL installation.

Sybase

SYBASE

Set the variable to the path in which Sybase Open Client is installed.

SYBASE_OCS

OCS-15_0

In this section: