Informix - HP-UX - odbc.ini, uvodbc.config ,dsenv

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
akrzy
Participant
Posts: 121
Joined: Wed Dec 08, 2004 4:46 am

Informix - HP-UX - odbc.ini, uvodbc.config ,dsenv

Post by akrzy »

Hi,
I have really big request.
I have problem with configuration odbc to use connection with Informix 7.31 on HP-UX.

Could someone show me configuration files:
odbc.ini,
uvodbc.config
and
dsenv ?

Perhaps I forgot about something.

I need any example files to compare with mine.

Thanks a lot for any help!!!

Anka
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

While these are on AIX, they should transfer happily. We are connecting (successfully) from DataStage to Informix 7.3.1. Only pertinent sections of the three files are shown.

uvodbc.config

<Policies>
DBMSTYPE = ODBC

.odbc.ini

[ODBC Data Sources]
DB2 Wire Protocol=DataDirect 4.2 DB2 Wire Protocol Driver
dBase=DataDirect 4.2 dBaseFile(*.dbf)
Informix=DataDirect 4.2 Informix
Informix Wire Protocol=DataDirect 4.2 Informix Wire Protocol
Oracle=DataDirect 4.2 Oracle
Oracle Wire Protocol=DataDirect 4.2 Oracle Wire Protocol
SQLServer Wire Protocol=DataDirect 4.2 SQL Server Wire Protocol
Sybase Wire Protocol=DataDirect 4.2 Sybase Wire Protocol
Text=DataDirect 4.2 TextFile(*.*)
Policies=Policies PS Data Source Non Wire

[Policies]
QEWSD=38224
Driver=/progs/dstage/Ascential/DataStage/branded_odbc/lib/VMinf5119.so
Description=Policies
Database=Policies
LogonID=uid
Password=pwd
ServerName=PoliciesServer
HostName=wcau010
Protocol=onsoctcp
EnableInsertCursors=0
GetDBListFromInformix=0
CursorBehavior=0
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1
PortNumber=1621

[ODBC]
IANAAppCodePage=4
InstallDir=/progs/dstage/Ascential/DataStage/branded_odbc
Trace=0
TraceDll=/progs/dstage/Ascential/DataStage/branded_odbc/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

dsenv

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bi
n:$LIBPATH:/progs/informix/lib/cli:/progs/informix/lib/esql:/progs/informix/lib/dmi:/progs/informix/lib/client
export LIBPATH
INFORMIXDIR=/progs/informix
INFORMIXSERVER=insite_dev
export INFORMIXSERVER
export INFORMIXDIR
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply