IBM GC09-2830-00 manual CATALOG user system ODBC DATA SOURCE, Quick Beginnings

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.

vOn 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. Con®gure the DB2 CLI/ODBC driver using the CCA: (Optional)

a.Select the DB2 database alias you want to con®gure.

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 con®guration 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 Con®guration 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 ®le 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.

124Quick Beginnings