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.
At IDUG EMEA 2025 I presented Db2 External Tables and answered questions. Here I show how to combine an external table with a regular table in SQL statements.