Oracle to DB2 Mapping

Oracle to DB2 Data Type Mapping

Note that mapping is one-to-many and depends on the actual usage of the data

DETAILS OF MAPPING
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