Docs‎ > ‎Integrate Menu‎ > ‎Data Sources‎ > ‎

IBM DB2 Data Source


Install the DB2 JDBC Driver

The DB2 driver is not included in the Jetty package. For more information about the supported versions of DB2 driver, see Supported Platforms.

Install the license file and the DB2 driver into the following directory:

  • (Jetty package) caliveapicreator/lib/ext directory.
  • (Tomcat) The Tomcat lib directory.

Connect to a DB2 Database

Prerequisites: You know your JDBC connection information.

Connect to a DB2 database by creating your API project. For more information about creating API projects, see Create your API Project.

  1. In the Create API wizard, select DB2 for z/OS or DB2 for LUW.
  2. Complete the host, port, and password fields, including the following fields, and then click Continue:

Database (for LUW)

This database value accepts double quotesUse double quotes to accept the value of mixed-case (non-standard) database value.

Location (for z/OS)

This database value accepts double quotesUse double quotes to accept the value of mixed-case (non-standard) location value.

Schema

This database value accepts double quotesUse double quotes to accept the value of mixed-case (non-standard) schemas name.

For example: "MySchema".

Username

This database value accepts double quotesUse double quotes to accept the value of mixed-case (non-standard) username.

DB2 Supported Data Types

Live API Creator supports read and write of the following IBM DB2 for Linux, UNIX, and Windows data types:
Data typeModeled as...
BOOLEAN
boolean
TIMESimpleTime
TIMESTAMP
SimpleTimestamp
DATESimpleDate
BLOB
binary
CHARstring
GRAPHICsring
REALfloat
DOUBLE
double
VARCHAR
string
LONG VARCHAR
string
CLOBstring
VARGRAPHIC
string
LONG VARGRAPHICstring
DBCLOB
string
SMALLINT
integer
INTEGERinteger
BIGINT
long
DECIMALdecimal
DECFLOATdecimal or double (infinity and NaN are modeled as doubles)
DISTINCT TYPE
Modeled as the underlying type.

For more information about the data type definitions, see the IBM Knowledge Center.