|
Oracle data type |
DB2 data type |
Notes |
|
CHAR(n) |
CHAR(n) |
1 <= n <= 254 |
|
VARCHAR2(n) |
VARCHAR(n) |
n <= 32762 |
|
LONG |
LONG VARCHAR(n) |
if n <= 32700 bytes |
|
LONG |
CLOB(2GB) |
if n <= 2 GB |
|
NUMBER(p) |
SMALLINT /
INTEGER /
BIGINT |
- SMALLINT, if 1 <= p <= 4
- INTEGER, if 5 <= p <= 9
- BIGINT, if 10 <= p <= 18 |
|
NUMBER(p,s) |
DECIMAL(p,s) |
if s > 0 |
|
NUMBER |
FLOAT /
REAL /
DOUBLE |
|
|
RAW(n) |
CHAR(n) FOR BIT DATA /
VARCHAR(n) FOR BIT DATA
BLOB(n) |
- CHAR, if n <= 254
- VARCHAR, if 254 < n <= 32672
- BLOB, if 32672 < n <= 2 GB |
|
LONG RAW |
LONG VARCHAR(n) FOR BIT DATA /
BLOB(n) |
- LONG, if n <= 32700
- BLOB, if 32700 < n <= 2GB |
|
BLOB |
BLOB(n) |
if n <= 2 GB |
|
CLOB |
CLOB(n) |
if n <= 2 GB |
|
NCLOB |
DBCLOB(n) |
if n <= 2 GB, use DBCLOB(n/2) |
|
DATE |
TIMESTAPMP |
- Use Oracle TO_CHAR() function to
extract for subsequent DB2 load.
- Oracle default format is
DD-MON-YY |
|
DATE (only the date) |
DATE (MM/DD/YYYY) |
- Use Oracle TO_CHAR() function to
extract for subsequent DB2 load. |
|
DATE (only the time) |
TIME (HH24:MI:SS) |
- Use Oracle TO_CHAR() function to
extract for subsequent DB2 load. |