- ODBC.INI File Settings

The odbc.ini file must contain a list of all the available ODBC datasources, and a list of all databases, instances and filetypes for all users.

Each PROIV user should have an odbc.ini file in their home directory. An example file is shown below.

[ODBC Data Sources]
SAMPLE=IBM DB2 ODBC DRIVER

[SAMPLE]
Driver=/db2/udb/db2inst1/sqllib/lib/db2.o
Description=Sample DB2 ODBC Database
Database=Company1

[ODBC]
Trace=0
TraceFile=odbctrace.out
InstallDir=/db2/udb/db2inst1/sqllib/odbclib

With the environment variables mentioned in the example above, SQL_DBNAME would be set to 'SAMPLE':

SQL_DBNAME=SAMPLE

If there were more than one datasource specified in the odbc.ini file, the SQL_DBNAME environment variable would select the default datasource for the user.

If tasks that use ODBC datasources are to be executed over the PROIV tasks, the home directory for operating system user-id (passed in with the task request) must have an odbc.ini correctly set up.

Comment on this topic

Topic ID: 720151