Specifying data source names in the uvodbc.config file
The uvodbc.config file must specify the ODBC data source name (DSN) for each database.
About this task
A copy of the uvodbc.config file exists in the $DSHOME directory and each project directory. For example, the default path for projects on Linux® is /opt/IBM/InformationServer/Server/Projects.
By default, IBM® InfoSphere® DataStage® searches the current project directory for a uvodbc.config file and, if it finds one, uses this file instead of $DSHOME. This file arrangement allows you to configure data sources that are known to some projects but not others.
Procedure
<DSN_name>
DBMSTYPE = ODBC
DSN_name is the ODBC DSN. This name must be the same name that is specified in the .odbc.ini file. The space on each side of the equal sign is required.
In the uvodbc.config file, comment lines begin with a number sign (#). Comments that are not in the comment block at the top of the file cause processing errors. Add comments only to the comment block that is at the top of the uvodbc.config file.
The following example shows a typical uvodbc.config 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
<DB2>
DBMSTYPE = ODBC