Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Environment Variables Need To Be Set On Unix Systems?

Users need to run openlink.sh or openlink.csh in the appropriate shell to set the following variables on all unix systems: CLASSPATH A JAVA client variable that passes the full path to an OpenLink JDBC .jar file. LD_LIBRARY_PATH A generic library path variable that appends the full path to OpenLink's lib sub-directory. LIBPATH An AIX library path variable that appends the full path to OpenLink's lib sub-directory. ODBCINI Passes the full path to ~/openlink/bin/odbc.ini. ODBCINSTINI Passes the full path to ~/openlink/bin/odbcinst.ini. OPENLINKINI This Single-Tier variable passes the full path to ~/openlink/bin/openlink.ini. PATH Appends the full path to OpenLink's bin sub-directory. SHLIB_PATH An HP/UX library path variable that appends the full path to OpenLink's lib sub-directory.

OpenLink's Multi-Tier ~/openlink/bin/oplrqb.ini file is a server side configuration file. Single-Tier ~/openlink/bin/openlink.ini file is a standard file that ships with all Single-Tier drivers. Both oplrqb.ini and openlink.ini contain a series of [Environment] sections. These environment sections pass variables that OpenLink components need to connect to specific databases. For example:

[Environment DB2]
DB2DIR             = /dbs/DB2
DB2INSTANCE        = DB2

[Environment INFORMIX2000]
INFORMIXSERVER     = oplussol3
INFORMIXDIR= /dbs/informix/ids2000


[Environment INGRES_II]
II_DATE_FORMAT     = US
II_SYSTEM          = /dbs
ING_SET            = set lockmode session where readlock=nolock

[Environment MYSQL]
CURSOR_SENSITIVITY = LOW

[Environment ORACLE90]
ORACLE_HOME= /dbs5/oracle8i/64-bit/8.1.6/
ORACLE_SID= ora816np


[Environment POSTGRES]
PGHOST             = localhost
PGPORT             = 5432


[Environment PROGRESS91D]
DLC                = /dbs3/progress/32bit/v91d
PROCFG             = /dbs3/progress/32bit/v91d/progress.cfg

[Environment PROGRESS91SQL]
DLC                = /dbs3/progress/32bit/v91d
PROCFG             = /dbs3/progress/32bit/v91d/progress.cfg

[Environment SYBASE]
FREETDSCONF        = /dbs/openlink/32bit/v51/mt/bin/freetds.conf
DSQUERY            = SYBASE
TDSHOST            = host.domain
TDSPORT            = 4100
TDSVER             = 5.0

[Environment SQLSERVER]
FREETDSCONF        = /dbs/openlink/32bit/v51/mt/bin/freetds.conf
;DSQUERY            = SQLSERVER
TDSHOST            = dyn252.openlinksw.com
TDSPORT            = 1433
TDSVER             = 8.0