SQL access to JSON documents
Creating a Db2® version 184.108.40.206 (or higher) database, or upgrading to Db2 V220.127.116.11, provides you with a new set of built-in JSON SQL functions that improve SQL interaction with JSON data.
With these functions, you can store, retrieve, and query JSON and BSON data directly using SQL. You can also create JSON documents using SQL.
As built-in functions, the Db2 JSON SQL functions reside in the SYSIBM schema and do not require users to hold any privilege on a function in order to invoke it.
The new built-in JSON SQL functions replace the original set of JSON SQL functions provided in the SYSTOOLS schema. While the new JSON SQL functions are the recommended approach, the original set of functions are still functional and will still be supported within Db2.