DB2

The following DB2 data types are supported by DataDirect database drivers:

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