Filter
Top Products
d. On Windows 32-bit operating systems you can use the radio
buttons to add the data source as either a user or system data
source.
v Using the Microsoft 32-bit ODBC Administration tool, which you
can access from the icon in the Control Panel or by running
odbcad32.exe from the command line:
a. On Windows 32-bit operating systems the list of user data
sources appears by default. If you want to add a system data
source click on the System DSN button, or the System DSN
tab (depending on the platform).
b. Click on the Add push button.
c. Double-click on the IBM DB2 ODBC Driver in the list.
d. Select the DB2 database to add and click on OK.
v On Windows 32-bit operating systems there is a command that can
be issued in the command line processor to register the DB2
database with the ODBC driver manager as a data source. An
administrator could create a command line processor script to
register the required databases. This script could then be run on all
of the machines that require access to the DB2 databases through
ODBC.
The Command Reference contains more information on the
CATALOG command:
CATALOG [ user | system ] ODBC DATA SOURCE
Step 4. Configure the DB2 CLI/ODBC driver using the CCA: (Optional)
a. Select the DB2 database alias you want to configure.
b. Click on the Properties push button. The Database Properties
window opens.
c. Click on the Settings push button. The CLI/ODBC Settings
window opens.
d. Click on the Advanced push button. You can set the configuration
keywords in the window that opens. These keywords are
associated with the database alias name, and affect all DB2
CLI/ODBC applications that access the database. The online help
explains all of the keywords, as does an appendix in the
Installation and Configuration Supplement online manual.
Step 5. If you have installed ODBC access (as described above), you can
now access DB2 data using ODBC applications. Start the ODBC
application and go to the Open window. Select the ODBC databases
file type. The DB2 databases that you added as ODBC data sources
will be selectable from the list. Many ODBC applications will open
the table as read-only unless a unique index exists.
124 Quick Beginnings