SQL enhancements

Db2 11.5.7 includes enhancements to the behavior of SQL statements within Db2.

Attention: This mod pack release is currently available for the following Db2 products: Db2 on Cloud and Db2 Warehouse on Cloud will be updated to version 11.5.7 early in 2022.
The following table displays SQL statement enhancements now available in 11.5.7:
Table 1. SQL statement enhancements in 11.5.7
Enhancement Description
RENAME TABLE statement enhancement The RENAME TABLE statement is now extended to support the renaming of tables with indexes on an expression. This feature is available when the expression does not contain qualified names.