I tested the Db2 Developer Extension together with IBM Bob, the AI-powered partner for the Software Development Lifecycle. For hands-on experience, I created an analytics solution for GBFS-based mobility data.
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.