Reading JSON with SQL on IBM i
A field holding JSON can be read with SQL. Four levels, from the first JSON_VALUE query to the cases where a value quietly comes out NULL.
Articles tagged #db2 — 7 results
What the IBM i MCP server is: An agent that queries Db2
IBM has published an open source bridge between AI agents and Db2 for i. What it actually does, what it takes to run, and what authority it works with.
Understanding journals and how to use them
The journal records every change to your data, with the time and the name of who made it. It exists for recovery, but day to day it mostly answers one question: who changed this record?
Optimizing SQL Queries on DB2 for i
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.
Reading a spooled file with SQL
Querying the contents of a spooled file without copying it into a physical file first.
Converting a CYYMMDD date in SQL
Turning the seven-digit format into a real date with a single expression.
The indexes the system suggests, and which to create
Db2 for i records which indexes it would have wanted, one query at a time. Creating them all is the quickest way to slow the database down.