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
Example
[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.