Oracle to DB2 Conversion Guide: Compatibility Made Easy

Data types

This appendix explains data types in the following environments:

•Supported SQL data types in C/C++

•Supported SQL data types in Java

•Data types available in PL/SQL

•Mapping Oracle data types to DB2 data types

B.1 Supported SQL data types in C/C++

Table B-1 provides a complete list of SQL data types, C and C/C++ data type mapping, and a brief description of each type.

For more information about mapping between SQL data types and C and C++ data types, see the following resources:

•Developing Embedded SQL Applications, SC27-2445