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 | 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...
by Andrea | 8 February 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
I often find myself needing to run several commands in QSH, and I have now found an alternative way to do this compared to the classic bash scripts. Once again, SQL comes to our aid. Now, using QSH in batch mode is very simple but requires a little attention. In our...
by Andrea | 17 January 2026 | IBM i, Programming, System Management
During the Christmas holidays, between various lunches with relatives, an outing, and, of course, some rest, I had the opportunity to rework the Code4i FS extension a bit. It was very challenging in that it allowed me to learn a new language, TypeScript, and to learn...
