SQL enhancements

Db2 12.1.3 includes new scalar functions for generating Universal Unique Identifier (UUID), which can improve performance during migration and replication operations, as well as the updating of unique IDs in large tables.

The following table displays SQL statement enhancements now available in Db2® 12.1.3:
Table 1. SQL statement enhancements in 12.1.3
Enhancement Description
New scalar functions for generating Universal Unique Identifiers (UUID) Customers have requested the ability to generate UUIDs by running a built-in database function, either to reduce the time taken to generate or update these values in large tables, or to ensure that table IDs remain unique during data replication and migration.
With the release of Db2 12.1.3, two new scalar functions have been brought over from Db2 for i systems, to provide this functionality:
VECTOR data type enhancements The VECTOR data type is enhanced for the Db2 12.1.3 release:
  • The VECTOR data type can now be cast to and from VARCHAR and CLOB data types.
  • The VECTOR data type is now supported by the following Db2 database objects:
    • Temporary tables.
    • External tables.
    • SQL routines.
    • The CREATE VARIABLE statement.