Connecting to an IBM DB2 database with the IBM DB2 Sybase SQL skin (SSacSA)

You can connect to a DB2® for Linux, UNIX, and Windows database as a Sybase ASE database if you use the ANTs Software product IBM® DB2 SSacSA. When you create a connection to the data source, you must add the location of the ANTs file antsjconn3.jar to the connection profile classpath.

The ANTs Software product IBM DB2 SQL Skin Feature for applications compatible with Sybase ASE (IBM DB2 SSacSA) supports connecting to a DB2 database as a Sybase ASE database.

Before you begin

The database you are connecting to must be a DB2 for Linux, UNIX, and Windows database that is running the ANTs product IBM DB2 SSacSA to emulate a Sybase ASE database.

The ANTs JAR file antsjconn3.jar must be accessible to the workbench and you must know the location of the file. The file is installed when you install IBM DB2 SSacSA.

About this task

When you create a connection profile with IBM DB2 Sybase SQL skin (SSacSA), you add the location of the file antsjconn3.jar to the profile classpath.

Procedure

To connect to a DB2 Sybase ANTs database:

  1. Create a new connection with the New Connection wizard.
  2. For JDBC Driver, select the IBM DB2 Sybase SQL skin (SSacSA) list item and click the browse button. The Edit JAR List window opens with the list of required JAR files.
  3. On the Edit JAR List window, click Edit JAR/.zip to specify the location of JDBC driver files and click OK.
    1. Specify the location of the ANTs antsjconn3.jar file.
    2. Specify the location of the DB2 JDBC JAR files db2jcc4.jar and db2jcc_license_cu.jar.

      The DB2 JDBC JAR files are included with Optim™ Development Studio. The files are in the shared plugins directory of the Optim Development Studio installation. For example, on a Windows computer the default directory is C:\Program Files\IBM\SDPShared\plugins\com.ibm.datatools.db2_version-id\driver

Results

After you connect to the to an IBM DB2 database that uses ANTs SSacSA, the connection lists the database type as Sybase 15.0.

You can view the database objects and develop and test SQL stored procedures on the database.

For known limitation when using IBM DB2 SSacSA with a DB2 database, see Known limitation when using IBM DB2 SSacSA and a DB2 database as a Sybase database.


Feedback