Db2 for i Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
binary(size), 1 <= s <= 2000 | raw(size), 1 <= size <= 2000 |
binary(size), 2001 <= s <= 32766 | blob |
char(size) for bit data, 1 <= s <= 32766 | blob |
char(size), 1 <= s <= 2000 | char(s byte), 1 <= s <= 2000 |
char(size), 2001 <= s <= 4000 | varchar2(s byte), 2001 <= s <= 4000 |
char(size), 4001 <= s <= 32766 | clob |
date | date |
decfloat(precision), 16 <= p <= 34 | char(255 char) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62 | char(s char), 40 <= s <= 65 |
float | binary_double |
integer | number(10) |
long varbinary | blob |
long varchar | clob |
long varchar for bit data | blob |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62 | char(s char), 40 <= s <= 65 |
real | binary_double |
rowid | blob |
smallint | number(5) |
time | char(8 char) |
timestamp(0) | date |
timestamp(precision), 1 <= p <= 9 | timestamp(precision), 1 <= p <= 9 |
timestamp(precision), 10 <= p <= 12 | char(s char), 30 <= s <= 32 |
varbinary(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
varbinary(size), 2001 <= size <= 32740 | blob |
varchar(size) for bit data, 1 <= size <= 32740 | blob |
varchar(size), 1 <= size <= 4000 | varchar2(s byte), 1 <= s <= 4000 |
varchar(size), 4001 <= size <= 32740 | clob |