DB2
The following DB2 data types are supported by DataDirect database drivers:
DB2 Data Type | JDBC Data Type |
---|---|
BIGINT | BIGINT |
BLOB | BLOB |
CHAR | CHAR |
CLOB | CLOB |
DATE | DATE or TIMESTAMP |
DECIMAL | DECIMAL |
DOUBLE | DOUBLE |
FLOAT | FLOAT |
GRAPHIC | CHAR or NCHAR |
INTEGER | INTEGER |
LONG VARCHAR | LONG VARCHAR |
LONG VARGRAPHIC | LONGVARCHAR or LONGNVARCHAR |
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.
Copyright © Cloud Software Group, Inc. All rights reserved.