SQL compatibility

You might have an application that was written for use with a relational database that is not your local database. Compatibility features enable such an application to use Db2 Big SQL with minimal changes to the application.

Compatibility features for Db2

IBM Db2, Db2 Warehouse on Cloud, and Db2 Big SQL are designed with compatible SQL DML. Various factors can affect compatibility. For more information about writing compatible SQL, see:

Write once and run everywhere: Common IBM SQL features for portable data application development
Selected common SQL features for developers of portable Db2 applications

In general, Db2 Big SQL compatibility is constrained by the underlying Hadoop ecosystem. This compatibility therefore pertains to queries and does not include full ACID transaction support.

Beyond SQL syntax compatibility, it is important to also consider the surrounding operating environment, including collation, isolation level, and data types.