Featured image of post Db2 and UUID explained

Db2 and UUID explained

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.

Featured image of post Db2 and JSON array access

Db2 and JSON array access

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.

Featured image of post Db2 vector for GEO search

Db2 vector for GEO search

Today, I show you how the Db2 vector feature can be used for simple geo search like finding neighboring cities.