// Category
DB2 for i
SQL, embedded SQL in RPG, database design and optimization on IBM i.
[DB2 for i]
A comprehensive guide to DB2 for i JSON and XML functions in 2026: extracting scalars with JSON_VALUE, shredding arrays with…
[DB2 for i]
A comprehensive guide to DB2 for i SQL stored procedures and user-defined functions in 2026: CREATE PROCEDURE syntax, IN/OUT parameters,…
[DB2 for i]
DB2 for i triggers fire automatically on INSERT, UPDATE, and DELETE, enforcing rules that application code cannot bypass. This post…
[DB2 for i]
Vector search and text embeddings bring semantic search to IBM i in 2026 — converting DB2 for i text fields…
[DB2 for i]
DB2 for i replication in 2026 is built on IBM i journals — the same journal receivers that underpin HA…
[DB2 for i]
Advanced DB2 for i query performance: the SQE versus CQE split and what it means for your queries, column statistics…
[DB2 for i]
Every physical file you have ever defined in DDS, every CHAIN and READ in your RPG programs, every logical file…