Mapping Oracle data types to DB2 UDB data types

---

Table 9-7 summarizes the mapping from the Oracle data types to corresponding DB2 data types. The mapping is one to many and depends on the actual usage of the data.

Table 9-7: Mapping Oracle data types to DB2 UDB data types

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.

---