Starting with version 12.1.3, Db2 now features GENERATE_UUID and GENERATE_UUID_BINARY functions. We explain what UUIDs are and how to use the new functions.
Db2 supports JSON data and querying it with SQL, but access to JSON arrays, especially unnesting that data, is tricky. Great, if there is some background in recursive SQL.