Configuring access for the Informix CLI, Informix Load, and Informix XPS Load stages

For the Informix® CLI, Informix Load, and Informix XPS Load stages to access Informix databases, you must set the values of environment variables and add data source name (DSN) entries to the .odbc.ini file.

Before you begin

  • Install the IBM® Informix server.

Procedure

  1. Set the INFORMIXDIR environment variable to point to the installation directory of the IBM Informix server.
  2. Make sure that the PATH environment variable contains $INFORMIXDIR/bin.
  3. Make sure that the library path environment variable contains$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql/$INFORMIXDIR/lib/cli.
    The following is an example of environment variable settings on an AIX® system.
    INFORMIXDIR=/opt/informix/IDS
    LIBPATH=/opt/informix/IDS/lib:/opt/informix/IDS/lib/esql:/opt/informix/IDS/lib/cli
    PATH=/opt/informix/IDS/bin
  4. For the Informix CLI stage, if the data source uses a translation DLL, you must add INFORMIXDIR/lib/esql to the shared library search path.
    If INFORMIXDIR/lib/esql is not added, a message that is related to loading translation DLL is logged in the IBM InfoSphere® DataStage® job log.

Example

The following example shows sample DSN entries for AIX, HP, and Linux® platforms.
[Informix]
Driver=/home/informix/csdk/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=<stores_demo>
LogonID=<user_id>
Password=<password>
ServerName=<informixserver>
HostName=<informixhost>
Service=<online>
Protocol=ontlitcp EnableInsertCursors=0 GetDBListFromInformix=0 
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1  
CursorBehavior=0 CancelDetectInterval=0 TrimBlankFromIndexName=1 
ApplicationUsingThreads=1 TRANSLATIONDLL=/home/informix/csdk/lib/esql/igo4a304.so
</online></informixhost></informixserver></password></userid></stores_demo>

Every Informix data source to which the IBM InfoSphere DataStage jobs connect must have an entry in the .odbc.ini file. You must specify values for the Database and Server name properties. The CLIENT_LOCALE and DB_LOCALE fields are optional. If you add login ID (UID) or password (PWD) properties, the User Name and Password properties can be left blank. The values that are specified for the login ID (UID) and password (PWD) properties override the values that are specified for the User Name and Password properties in the .odbc.ini file.