We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, February 07, 2013

.odbc.ini file in DataStage


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