Lists DB2 UDB-to-HANA DB datatype mappings.
DB2 UDB Datatype |
Replication Definition Datatype |
HANA Datatype |
---|---|---|
BIGINT |
rs_udb_bigint |
bigint |
BLOB |
image |
blob |
CHAR |
char |
char (See note below.) |
CHAR FOR BIT DATA |
rs_udb_char_for_bit (up to 255 bytes) varbinary (greater than 255 bytes) |
varbinary |
CLOB |
text |
clob |
DATE |
rs_udb_date |
date |
DBCLOB |
unitext |
nclob |
DECFLOAT(16) |
rs_udb_decfloat |
float |
DECFLOAT(32) |
rs_udb_decfloat |
decimal |
DECIMAL |
decimal |
decimal |
DOUBLE |
rs_udb_double |
double |
GRAPHIC |
unichar |
nchar |
INTEGER |
integer |
integer |
LONG VARCHAR |
text |
clob |
LONG VARCHAR FOR BIT DATA |
image |
blob |
LONG VARGRAPHIC |
unitext |
nclob |
REAL |
rs_udb_real |
real |
SMALLINT |
smallint |
smallint |
TIME |
rs_udb_time |
time |
TIMESTAMP(12) |
rs_udb_timestamp12 |
timestamp |
VARCHAR |
varchar |
varchar (See note below.) |
VARCHAR FOR BIT DATA |
rs_udb_varchar_for_bit (up to 255 bytes) varbinary (greater than 255 bytes) |
varbinary |
VARGRAPHIC |
univarchar |
nvarchar |