by Robert Indrigo | Published August 9, 2017
Many of IBM’s database customers and independent software vendors have expressed interest in writing portable applications across multiple platforms. IBM® is committed to delivering SQL commonality, on database platforms implementing the Common SQL Engine, in a way that is common and portable and supports the ANSI/ISO SQL standards. These customers’ application developers have asked us to provide them with a list of common SQL language capabilities as a quick reference.
Db2 is now the brand name for all of IBM’s hybrid data management offerings, including products previously named dashDB. IBM Db2® and IBM Big SQL are designed with compatible SQL. Applications that access data stored on these products using compatible SQL via one of the IBM data server drivers should operate without change against data stored on the rest of the products. Specific detail and factors affecting compatibility are noted in the tables.
A feature might not be available on all common SQL engine products on exactly the same date. In some cases, this is only because the different Db2 products ship on slightly different schedules. In other cases, this is because customer requirements can accelerate development of an SQL feature on a specific Db2 product.
This summary version of the common SQL application features is intended to be a quick reference and includes the frequently used features and functions across the platforms. For more detailed information, consult the SQL Reference for cross-platform development (PDF 4.2 MB) and the respective IBM SQL product SQL Reference books. Read the disclaimer before using the tables.
This list is not necessarily complete. Selected features are based on frequent customer interest. You can find more common features by examining the SQL language Reference books for products in detail.
This list is not intended to be a feature and function list for any of the Db2 products. A feature might already appear on one platform and be in the process of rolling out on other Db2 platforms because new functionality continues to be shipped all the time. Because of the differences in customers and marketplaces, not all platforms require the same features delivered at the same time.
April 23, 2019
May 15, 2019
May 9, 2019
Back to top