Welcome to our articles page
If you cannot see what you are after, use the search box below
The Year of Many Changes
By2025 began a month ago. It is now February 2025, and we are back to our daily responsibilities: tickets, customer calls, and our regular routines. We’ve already forgotten our New…
Choosing the Right Language on IBM i
ByRPG, ILE, SQL & Open-Source Programming Our grandchildren have just started secondary school and along with the expected French, Spanish and German they have been offered Mandarin. Everyone has welcomed…
Mapepire Introduction
ByIn my last couple of articles, I have shown python accessing data on the IBM i, accessing both DB2 for i and SQLite. The SQLite article used an SQLite package…
Webinar: Planning a Successful IBM i 7.6 Upgrade
16 October | 4 P.M. BST
Join IBM i expert Pete Massiello as he walks you through the essential steps to prepare for your next upgrade.
From prerequisites to post-installation requirements, this session will equip you with the knowledge and confidence to complete your upgrade correctly.
Previous Posts
A screen a story – A User Reporting Slow ODBC Performance
In my last article I wrote: “IBM i Services allows a modern system administrator to move away from having to use 5250 emulation, not because you should, but because using…
ByA screen a story – The Contact Information National language version
Recently Scott Forstie created an SQL script allowing you to create a procedure with which it is a piece of cake to review the special instruction PTFs. What the link…
Environment Variables
The IBM i operating system is highly dependent on environmental variables, which can have a significant impact on its performance. In this article, we will dive into the various environmental…
A Note from the Chairman
Well, if we thought that 2022 was a whirlwind – that saw much of business come back together and saw i-UG really step up to the mark in trying to…
ByA screen a story – The Run SQL Scripts bottom bar
If IBM is following the same schedule as it has in previous years it is fair to say that a new version of IBM i Access Client Solution (ACS) is…
DB2 for i Multisystem
In this article I will be taking a look at a feature we should all be installing, and using, on our IBM i servers. As I mentioned in a recent…
A screen a story – What does “move active records” mean?
The latest Technology Refresh (TR) for IBM i 7.4 and 7.5 has something new within them for reorganizing a file. If you have lost count of the TR levels IBM…
Node-RED & Security
I gave a quick demonstration of Node-RED to a client recently and I didn’t get the response I was expecting. On bringing up the Node-RED browser interface, the first question…
Node-RED & Bank Holidays
In a recent training course I gave to a UK bank, we were covering web-services and I showed how we can get information from a reliable source and then store…
A screen a story – What does this button do? Part II
In my last article A screen a story – What does this button do? The SQL button was used to retrieve SQL statements which I then tweaked to get the…
Node-RED & IBM i
In my last article I wrote about the hoops we had to jump through to get the DB2 for i Node-RED adapter installed. In this article, we will be taking…
Node-RED & DB2 for i Connector
I know I said in my last article that was the end of my little project on the Raspberry Pi with Machine Learning talking to the IBM i. Well since…