Adapter Online Help > TDV DB2 Adapter > Data Type Mappings > DB2-on-z/OS Cache Mapping
 
DB2-on-z/OS Cache Mapping
The data type mappings for caches stored on DB2 (z/OS platform) are as follows.
Data Type
Native Type
BIGINT
BIGINT
BINARY
BLOB
BIT
SMALLINT
BLOB
BLOB
BOOLEAN
SMALLINT
CHAR
CHAR
CLOB (if > 254 bytes)
CLOB
CLOB
DATE
DATE
DECIMAL
DECIMAL
CLOB (if precision >31)
DOUBLE
DOUBLE
FLOAT
DOUBLE
INTEGER
INTEGER
NUMERIC
DECIMAL
CLOB (if precision >31)
REAL
REAL
SMALLINT
SMALLINT
TIME
TIME
TIMESTAMP
TIMESTAMP
TINYINT
SMALLINT
VARBINARY
BLOB
VARCHAR
VARCHAR
CLOB (if length >255)
XML
CLOB