Category: Featured
-
Stretch Imagination with SQL Part1
Scenario Let’s take a simple query like. It gives quite useful information, right? In fact, 109 columns of information that I have to scroll through all right through the screen. and so forth. Now, what if I want to track these metrics, say over a dimension of time, more easily? I have at my disposal…
-
Your Guide to Using cURL
At the two recent i-UG (the largest IBM i User Group in the UK), I gave a presentation about three great open-source utilities on the IBM i. Those being: Having just checked, I have written about the last two on PowerWire, so for completeness, I must write about cURL. A very powerful utility, so what…
-
IBM i 7.6 Release
From Steve Will on the 8th April 2025 Happy new release day IBM i community! Welcome to 2025 and my first blog of the year. We are starting the new year off with a big one, as today we announce IBM i 7.6 and IBM i 7.5 TR6. Anyone following closely in the community, or…
-
Say Hello to IBM i 7.6
Big, Bold & Better Than Ever! Attention, IBMi fans! The wait is over, and the latest and greatest version—IBMi 7.6—is finally here. Who would have guessed that name! Let us have a quick light-hearted look at this release. We cannot be serious all the time. If IBMi were a superhero, this release would be its…
-
A Month of Security Problems
Before we begin my article, let me talk about CVEs. A CVE, or Common Vulnerabilities and Exposures, is a standardised system for identifying and cataloguing security vulnerabilities in software and hardware. Vulnerabilities identified with a CVE are often assigned a severity rating using the Common Vulnerability Scoring System (CVSS). This system evaluates the impact of…
-
Collection Services Q & R
The “R” in the title is no typo, no Q & A this time. The “R” does refer to the name Collection Services Collection in the screen shot, which is available in two flavours, but what is the difference? Well, that is a question that is easy to answer. There are two kinds of collection…
-
The Year of Many Changes
2025 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 Year’s resolutions. Let me remind you of a few tasks you need to accomplish this year. Buy a Power10 server This is the most important…
-
Choosing the Right Language on IBM i
RPG, 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 this as ‘moving with the times’ and adding another ‘useful string to their bow’. In this ever-shrinking world it is an advantage to be multi-lingual.…
-
Mapepire Introduction
In 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 to get the data, and for the DB2 for i example I used ODBC to retrieve data from the IBM i. In this article I’ll…
-
noxDB Intro
In November 2024 I was invited to the Benelux Common conference in the Netherlands to give a couple of workshops, and what a great event it was. I had the opportunity to meet up with a good friend of mine Niells Liisberg from Denmark, where we had time to look at a couple of projects…
-
Passwords: Looking Ahead
Be it auditors, the recent NIS2 Directive , or just common sense, stepping away from IBM i user profiles with never expiring passwords has always been the better choice. Since IBM i has been around for quite some time, a lot of the security options have gotten a bit long in the tooth. For sure,…
-
