This is a Part of ODBC Configuration in DataStage tutorial.
Update the .odbc.ini File
The .odbc.ini file creates the relationship between the datasource name and the odbc driver that is supposed to be used to connect to it.
The .odbc.ini file is located in the DSHOME directory
- Telnet to the datastage server machine
- Change to the DSHOME directory (cd $DSHOME)
- Edit the .odbc.ini file
- Add the following section. Replacing DSN with the name you specified above.
- Make sure to update the IPAddress and Database Entry.
.odbc.ini EXAMPLE file
[ DSN ]
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMdb221.so
Description=DataDirect 5.10 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=NULLID
Database=
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=servername.boulder.ibm.com
IsolationLevel=CURSOR_STABILITY
Location=DBNAME
LogonID=
Password=
Package=NULLID
PackageOwner=
TcpPort=PORTNUMBER
WithHold=1