SQL compatibility enhancements
Db211.5.1 contains enhancements that reduce the time and complexity of enabling applications that were written for other relational database products to run in Db2 environments.
Note: The enhancements in this topic are included in the Db2 11.5.1 mod
pack release, which is available for the following Db2 products:
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
- The container micro-service deployment of Db2 on Red Hat OpenShift
- The Db2 cartridge used by IBM Cloud Pak for Data
The following table displays a list of SQL compatibility enhancements in the container-only
release of Db2
11.5.1:
Enhancement | Description |
---|---|
Netezza expressions now able to be referenced in a WHERE clause by an alias | A new Netezza® Platform Software (NPS) compatibility feature allows expressions to be referenced in the WHERE clause by its alias in a select list. |
New module added to the SYSIBMADM schema | A new module, DBMS_LOCK, has been added to the SYSIBMADM schema. The DBMS_LOCK package makes Oracle lock management services available to PL/SQL developers. |