Db2 for z/OS Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
binary(size), 1 <= size <= 255 | raw(size), 1 <= size <= 255 |
char for bit data | blob |
char(size) for bit data, 2 <= size <= 255 | blob |
char(size), 1 <= size <= 255 | char(s byte), 1 <= s <= 255 |
date | date |
decfloat(precision), 16 <= p <= 34 | char(255 char) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | number(p,s), 1 <= p <= 31, 0 <= s <= 31 |
float | binary_double |
integer | number(10) |
long varchar | clob |
long varchar for bit data | blob |
real | binary_double |
rowid | blob |
smallint | number(5) |
time | char(8 char) |
timestamp(0) | date |
timestamp(precision) with time zone, 0 <= p <= 9 | timestamp(precision) with time zone, 0 <= p <= 9 |
timestamp(precision) with time zone, 10 <= p <= 12 | char(s char), 70 <= s <= 72 |
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 <= 32704 | blob |
varchar(size) for bit data, 1 <= size <= 32704 | blob |
varchar(size), 1 <= size <= 3501 | varchar2(s byte), 1 <= s <= 3501 |
varchar(size), 4001 <= size <= 32704 | clob |