 
|
|
|
| Oracle Data Type |
 Notes |
DB2 Data Type |
Notes |
| BLOB |
n<=4 GB |
BLOB(n) |
- if n<=2GB use BLOB(n) |
| CLOB |
n<=4 GB |
CLOB(n) |
- if n<=2GB use CLOB(n) |
| DATE |
|
DATE
TIME
TIMESTAMP |
- if MMDDYYY required, then use DATE. |
| LONG |
n<=2GB |
LONG VARCHAR(n)
CLOB(n) |
- if n<=32700 bytes, use LONG VARCHAR
- if n<=2 GB, use CLOB
|
| NCLOB |
n<=4 GB |
DBLOB(n) |
- if n<=2GB use NCLOB(n/2) |
| NUMBER |
|
INTEGER
DECIMAL(p.s)
FLOAT(n) / REAL / DOUBLE |
- if Oracle decl is NUMBER(p), use SMALLINT / INTEGER
- if Oracle decl is NUMBER(p,s), use DECIMAL(p,s)
- if Oracle decl is NUMBER, use FLOAT(n) / REAL / DOUBLE
|
| RAW(n) |
n<=255 |
CHAR(n) FOR BIT DATA
VARCHAR(n) FOR BIT DATA
BLOB(n) |
- if n<=254, use CHAR(n) FOR BIT DATA
- if n<=32,672 bytes, use VARCHAR(n) FOR BIT DATA
- if n<=2 GB, use BLOB(n)
|
| VARCHAR2(n) |
n<=4,000 |
VARCHAR(n) |
n<=32762 |
|
|
|
