DB2

DataDirect database drivers support DB2 data types.

DB2 Data Type	JDBC Data Type
BIGINT Note: Supported for DB2 V9.1, V10 for z/OS.	BIGINT
BLOB Note: Supported only for DB2 V8.1 and later versions for Linux/UNIX/Windows, DB2 for z/OS, and DB2 V5R2 for iSeries.	BLOB
CHAR	CHAR
CLOB	CLOB
DATE	DATE or TIMESTAMP Note: For DB2 V9.7 for Linux/UNIX/Windows with the Oracle compatibility feature enabled, the Date type maps to the JDBC TIMESTAMP type.
DECIMAL	DECIMAL
DOUBLE	DOUBLE
FLOAT	FLOAT
GRAPHIC	CHAR or NCHAR Note: When JDBCBehavior=0, the data type depends on the JVM the application uses. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
INTEGER	INTEGER
LONG VARCHAR	LONG VARCHAR
LONG VARGRAPHIC	LONGVARCHAR or LONGNVARCHAR Note: When JDBCBehavior=0, the data type depends on the JVM the application uses. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
NUMERIC	NUMERIC
REAL	REAL
SMALLINT	SMALLINT
TIME	TIME
TIMESTAMP	TIMESTAMP
VARCHAR	VARCHAR

Limitations of Using DB2 Data Types

Note: When you select the DB2 OS390 database from the Vendor list in the Configuration tab, note the following conditions:

When creating a table that includes these data types, BLOB, CLOB, and VARCHAR, you can create the publishing table by selecting Publish by Reference storage mode.
When creating a table with the CLOB or BLOB as the data type, and the data maximum value exceeds 32K limit, then the Subscription Service will not accept the data.
When creating procedure, datatype LONGVARCHAR and LONGVARGRAPHIC are not supported in DB2 for zOS.
When creating an opaque exception table, you need to create a new LOB table space first, and then create the corresponding auxiliary table and the index.
When you insert a table with DECIMAL or NUMERIC data type into a project, if you request the numbers with high precision, you need to choose string instead of r8 in AE Type in the Table tab.