Featured image of post Db2 Valentine's Day Special

Db2 Valentine's Day Special

Get ready for Valentine's Day and show your love. Use your favorite database system, Db2, to print a heart and possibly other ASCII art.

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.