Page 1 of 1

dsenv and odbc.ini file setup

Posted: Tue Aug 30, 2005 1:44 am
by ewartpm
I need to connect to the following databases:
Informix Dynamic Server 9.4
DB2 UDB 8.1.6

We are using the Data Direct Wire Protocol 4.2 drivers.

We want to use the bulk loader stages for these databases (DB2 Load and Informix Loader stages).

Strange thing is we can connect using the ODBC stage, but cannot connect sing the Informix CLI stage or the DB2 stage. (ODBC will not do bulk loading).

Can anyone point me in the right direction. If anyone would be prepared to share their dsenv and odbc.ini setup it would be greatly appreciated. :)

Posted: Tue Aug 30, 2005 4:47 am
by roy
Hi,
Using the native plugins requires different configuration.
search this forum and the docs that describes configuratiojn requirements for those plugins.

P.S.
As previously mentioned here invoking the native bulk load utilities of each tool might proove to be more eficiant then using the bulk load stages.

IHTH,