Data type mapping from DB2 to Oracle 1

[Sina]

Hello everyone.

Where can I find some documentiation on data type mapping from IBM DB2 to oracle.

I'm in the process of migrating a db2 database to oracle 8i and 9i and would like to find some documentation (like in excell sheet or something) that will outline the data type mappings.

Thank you all.

 

[jee]

This is from the Oracle 8i Concepts Manual:

Table 12-4 SQL/DS, DB2 Datatype Conversions to Oracle Datatypes

DB2 or SQL/DS Datatype  Oracle Datatype  
CHARACTER (n)           CHAR (n) 
 
VARCHAR (n)             VARCHAR2 (n) 
 
LONG VARCHAR            LONG 
 
DECIMAL (p,s)           NUMBER (p,s) 
 
INTEGER, SMALLINT       NUMBER (38) 
 
FLOAT (p)               FLOAT (p) 
 
DATE                    DATE