by Andrea | 28 June 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
Recently, a client reported performance issues with some of his new SQLRPGLE programs that were retrieving data via REST APIs provided by the other party. Now, after doing a bit of analysis, we immediately identified the cause of that slowness: the SYSTOOLS HTTP...
by Andrea | 3 June 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
Managing objects in the IBM i QSYS file system has always been a challenge. The traditional approach requires switching between multiple CL commands ‘WRKOBJ’, ‘WRKJOB’, ‘WRKSPLF’, ‘DSPOBJ’, each with its own interface...
by Andrea | 17 April 2026 | IBM i, Sql Tricks & Tools, System Management
I often find myself needing to search through tape catalogs to locate specific libraries or datasets, and manually reviewing DSPTAP spool files for each tape becomes tedious very quickly. So I decided to wrap the DSPTAP command in a SQL table function to make batch...
by Andrea | 14 March 2026 | IBM i, Programming
In today’s article, we will see how it is possible to integrate an MCP server installed directly on IBM i with BOB, and yes, it can be done with very interesting results. An MCP (Model Context Protocol) server is middleware that allows you to define a set of...
by Andrea | 7 March 2026 | IBM i, Programming
A few weeks ago, I wrote an article about BOB in which I talked about my initial experience and how I had used it in Java. Now, some time later and after reaching the $200 ceiling, let’s talk about support for typical IBM i languages, RPG, and CL. We are still a...