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 | 22 February 2026 | IBM i, System Management
The ACS tool is very convenient and rich in features that go beyond simple 5250 emulation. In fact, this tool can be used to perform database management and maintenance operations, transfer IFS data or database files rather than spools. These are some of its...
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 | 25 January 2026 | IBM i, Sql Tricks & Tools, System Management
This week, a customer opened a ticket complaining that there were too many job logs on their system… this meant that when a user searched for their print job with WRKSPLF, they were inundated with a considerable number of job logs, making it difficult to find the...
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...
by Andrea | 2 January 2026 | IBM i, Sql Tricks & Tools, System Management
System security is becoming one of the most important issues that IT managers have to deal with. This also applies to IBM i systems. In fact, the days when the only access to systems was via a terminal are long gone. Now systems are at the center of complex ecosystems...
