Connecting to data sources : Defining environment variables
 
Defining environment variables
The installation program defines environment variables for data sources that you specify during installation, but if you want to connect to data sources later, you need to set these variables.
On Linux, insert the library path environment definition in the file pmd11.sh in AC_SERVER_HOME/bin. The library path variable names are:
*LD_LIBRARY_PATH for Linux
*SHLIB_PATH for HP-UX
On Windows, you define system, not user, environment variables. iHub processes are system processes, and cannot access the user environment. Windows uses PATH to search for libraries and executable files.
In some cases, environment variables or registry entries affect the capability to display documents in different languages.
Table 14‑1 lists data source-related Actuate registry keys on Windows, and environment variables on Linux and Windows.
Table 14‑1 Environment variables 
Key or variable name
Description
AC_DBMS_INFORMIX_MAXVARLEN
Maximum column length Actuate uses with Informix data sources. Default value is 4000.
AC_DBMS_ODBC_MAXVARLEN
Maximum column length Actuate uses with ODBC data sources. Default value is 8000.
AC_DBMS_ORACLE_MAXVARLEN
Maximum column length Actuate uses with Oracle data sources. Default value is 4000.
AC_DBMS_PROGRESS_MAXVARLEN
Maximum column length Actuate uses with Progress data sources. Default value is 4000.
DB2COMM
DB2 information.
DB2DIR
The path to the DB2 client installation.
DB2INSTANCE
Specifies the DB2 instance name.
DISPLAY
Linux. Specifies the X Windows server used by the machine.
DLC
Progress 9.1 installation directory.
INFORMIXDIR
The directory where the Informix product is installed.
INFORMIXSERVER
Specifies the name of the Informix data source.
INSTHOME
Inherited from shell and used by third-party processes.
ORACLE_HOME
The path to the Oracle installation.
SYBASE
The path to the Sybase installation.
SYBASE_OCS
The path to the Sybase OpenClient installation.