Performance tuning on IBM i: finding bottlenecks and reading query plans
Performance problems on IBM i tend to fall into a small number of categories. A query that reads every record […]
Operations & Admin
Operations & Admin
Operations and admin on IBM i: job queues, output queues, and keeping the system running
Every IBM i developer eventually ends up doing some administration. A job gets stuck. The output queue fills up. A
Modern Integrations
Modern integrations on IBM i: calling REST APIs and working with JSON
IBM i has been talking to other systems for decades. EDI over AS/400 communications, FTP file drops, MQ message queues
IFS & File Systems
IFS and stream files on IBM i: the bridge to the outside world
Most IBM i developers spend their entire careers working with physical files and never touch the IFS. That is understandable
DB2 for i
DB2 for i: the database hiding in plain sight
Every physical file you have ever defined in DDS, every CHAIN and READ in your RPG programs, every logical file
CL Commands
CL commands for RPG programmers: the system layer you cannot ignore
If you write RPG, you already use CL whether you realise it or not. Every time you submit a job,
RPG Programming
Embedded SQL in RPGLE: query your data the way you think about it
You already know how to read files with READ and CHAIN. They work. But the moment your query involves a
RPG Programming
Subprocedures and Service Programs in RPGLE: write once, call everywhere
Subprocedures let you break logic into reusable blocks inside a single program. Service programs take it further — compile your procedures once and share them across every program on the system.
RPG Programming
Free-format RPG: A practical guide for intermediate developers
You already write RPG. Free-format does not replace what you know — it removes the straitjacket. No more counting columns, no more cryptic opcodes. Here is how to make the switch.
IBM i Modernization: Cut Legacy AS400 Costs by 30%
A practical enterprise guide to IBM i modernization covering APIs, RPG transformation, AI-assisted modernization, and legacy system evolution.