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