IBM GC09-2830-00 manual Detailed Conguration Information, Quick Beginnings

2)Click on the Add push button from the Data Sources window. The Add Data Source Window opens.

3)Double-click on the IBM DB2 ODBC DRIVER in the list.

4)Select the DB2 database to add and click on OK.

3.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 appears. 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 manual.

4.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.

Detailed Con®guration Information

The section ªPlatform Speci®c Details for CLI/ODBC Accessº on page 123 should provide you with all of the information you require. Installation and Con®guration Supplement includes additional information on setting up and

using DB2 CLI and ODBC applications. (The online Installation and Con®guration Supplement manual is located in the directory x:\doc\en\html,

where x: is the letter that designates your CD-ROM and en is the two-character country code that represents your language, for example en for English.) This information is useful where DB2 tool support is not available, and for administrators who require more detailed information.

The following topics are covered in the Installation and Con®guration Supplement online manual:

vHow to Bind the DB2 CLI/ODBC Driver to the Database

vHow to Set CLI/ODBC Con®guration Keywords

vCon®guring db2cli.ini

126Quick Beginnings