Description
PowerBuilder and InfoMaker now provide the INTERSOLV DB2 ODBC driver for access to the IBM DB2 family of databases through the Powersoft ODBC interface. The DB2 family of databases includes:
- DB2 for Windows NT
- DB2 for OS/2 (formerly Database Manager for OS/2)
- DB2/6000
The INTERSOLV DB2 ODBC driver goes through IBM Client Application Enabler (CAE) Version 2.1 client software to make the connection. Therefore, you must have CAE Version 2.1 or higher installed on your client machine to use the INTERSOLV DB2 ODBC driver.
Supported platforms
The INTERSOLV DB2 ODBC driver is available on the following operating system platforms:
- Windows NT
- Windows 95
- Windows 3.x
- UNIX (Solaris, HP-UX, and AIX)
Purpose
The INTERSOLV ODBC DB2 driver lets you access an IBM DB2 database in PowerBuilder or InfoMaker through the Powersoft ODBC interface and CAE Version 2.1 or higher client software.
Preparing to use the DB2 data source
Before you define and connect to a DB2 data source in PowerBuilder or InfoMaker with the INTERSOLV DB2 ODBC driver, follow these steps to prepare the data source for use.
- To prepare a DB2 data source for use with the INTERSOLV DB2 ODBC driver:
- Make sure the required database server and (if required) network software is installed.
The IBM DB2 Server must be installed as the Server Version (not the Local Version).
- Make sure the IBM DB2 Client Application Enabler (CAE) software Version 2.1 or higher is installed on the client machine.
- Before the first user connects to the database in PowerBuilder or InfoMaker, run the appropriate bind file on the DB2 database server for the kind of cursor support you want.
What you do Before the first PowerBuilder or InfoMaker user connects to the database with the INTERSOLV DB2 ODBC driver, you must run one of the following DB2 SQL bind files once on the DB2 database server for the kind of cursor support you want:
|
Run this bind file
|
For this cursor support
|
|
QECSV1.BND
|
Read committed
|
|
QECSWHV1.BND
|
Read committed preserve cursor
|
|
QERRV1.BND
|
Repeatable read
|
|
QERRWHV1.BND
|
Repeatable read preserve cursor
|
|
QEURV1.BND
|
Uncommitted read
|
|
QEURWHV1.BND
|
Uncommitted read preserve cursor
|
How you do it To run a DB2 SQL bind file on the DB2 database server, you use the DB2 Command Line Processor that comes with the CAE client software. For instructions, see your IBM DB2 documentation.
Where to find the bind files The DB2 SQL bind files are located in the SERVER\INTERSOLV directory on the PowerBuilder or InfoMaker CD-ROM. They are not installed with PowerBuilder or InfoMaker.
Defining the DB2 data source
To connect to a DB2 database with the INTERSOLV DB2 ODBC driver, you must define a data source for the driver.
This procedure assumes that you have already prepared the DB2 data source for use (as described above) and installed the INTERSOLV DB2 ODBC driver that comes with PowerBuilder and InfoMaker.
- To define a DB2 data source for the INTERSOLV DB2 ODBC driver:
- Display the Configure ODBC dialog box.
- Select the INTERSOLV DB2 driver and click Create.
The ODBC DB2 Driver Setup dialog box displays.
- Click the Help button for information about how to specify values in the Setup dialog box.
- (Optional) Click the Advanced tab or button to configure additional connection options for the data source.
Click Help for information about how to specify optional settings for the INTERSOLV DB2 driver.
- Click the Catalog Db tab or button to catalog any DB2 database you want to access.
Click Help for information about how to catalog a DB2 database.
- Click the Catalog Node tab or button to provide required information about the remote node for DB2 databases.
Click Help for information about how to catalog the remote node.
- (Optional) To select an ODBC translator to translate your data from one character set to another, click the Translate button on the Advanced tab or in the Advanced Driver Setup dialog box.
- Click OK to save the data source definition.
|
