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

Monday, February 11, 2013

uvodbc.config File


This is a Part of  ODBC Configuration in DataStage tutorial.


Update the uvodbc.config File

The uvodbc.config is located in the root of the project directory (The project directory can be determined by opening DataStage Administrator, clicking on the Projects Tab, selecting the project)
This steps simply adds the datasource to the drop down list on the ODBC Import Screen

  • Telnet to the datastage server machine
  • Change to the project directory
  • Edit the uvodbc.config file
  • Add two lines that looks like this, where you replace the word DSN with the name of the datasource
    < DSN >
    DBMSTYPE = ODBC
  • Save the File


Example file :

[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<Sybase1>
DBMSTYPE = ODBC
<Sybase2>
DBMSTYPE = ODBC
<Oracle8>
DBMSTYPE = ODBC
<Informix>
DBMSTYPE = ODBC