DB2 for Linux, UNIX and Windows

Accelerate insight. Improve resiliency. Maintain flexibility.

Primary tab navigation

DB2 SQL compatibility

The DB2 SQL compatibility feature can greatly reduce the cost and risk of moving legacy applications built for the Oracle Database to DB2. Once on DB2, you can realize immediate cost savings with the flexible licensing terms from IBM. You can also take advantage of autonomics, deep compression, pureXML, and other advanced DB2 features to further lower your ongoing database ownership costs.


Simplify the move to DB2

Applications compatible with Oracle Database may contain business logic in the client code, triggers, or stored procedures that rely on PL/SQL, error handling, data types, and other behaviors which are unique to the database. In the past, this behavior dependency often meant moving to DB2 required extensive and risky code changes.

With the DB2 SQL compatibility feature, many of the behaviors that these legacy applications expect are now provided by DB2.

The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, and more. As a result, the need for application code changes to either the client or the stored procedures is minimized, which greatly simplifies the process of moving from Oracle to DB2.

Hit the ground running

Thanks to the built-in compatibility features, many clients have found that their staff can leverage existing skills and hit the ground running. For example, testers can reuse their existing test cases with few or no modifications.

Lower operational costs

Once you have moved to DB2, you can take advantage of advanced cost saving DB2 features like autonomics, deep compression, and pureXML to extend your cost savings. For example, the DB2 automatic self tuning capabilities will help your DBAs get up to speed quickly on DB2 and will relieve them of many of their mundane administrative tasks.

DB2 SQL compatibility resources


Simplify the move to DB2

Find solutions, industry reports, white papers, videos and more