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

.odbc.ini EXAMPLE file

This is a Part of  ODBC Configuration in DataStage tutorial.
This is Example file of .odnc.ini

[ODBC Data Sources]

TESTDB=DataDirect DB2 Wire Protocol Driver

DB2 Wire Protocol=DataDirect DB2 Wire Protocol Driver

dBase=DataDirect dBaseFile(*.dbf)

Informix=DataDirect Informix

.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

ODBC Configuration in DataStage

For configure the DataStage ODBC connections, need to edit three files to set up the required ODBC connections. These are:

• dsenv
• .odbc.ini
• uvodbc.config

All three are located in the $DSHOME directory. Copies of uvodbc.config are also placed in the project directories.