• Guru: Where’s The Table?

  September 14, 2026 Ted Holt

  It began with an irritation. I considered it a simple request. “Which file did my SQL query read?” I was using the Run SQL Scripts tool to modify an SQL query with unqualified table names. And yet I knew of no ready way to determine the schema (library) name of any of the files. How was I to know which tables I had just queried?

  Let me back up a bit. My SQL client of choice is the Run SQL Scripts tool, which is part of IBM’s Access Client Solutions (ACS). It is not unusual for me to copy and …

  Read more

• Oracle Dips A Toe Into IBM’s EBCDIC World

  August 24, 2026 Alex Woodie

  IBM’s Ted Codd may have invented the relational database back at the Almaden Lab in the early 1970s, but it was Larry Ellison’s Oracle that offered the world the first wildly commercially successful RDBMs. Technically, the System/38 was announced, with its integrated relational database, before the first version of Oracle was announced.

  Since then, Oracle and IBM have competed intensely to win and run transactional database workloads for some of the biggest enterprises around. But there was always one key difference between the two companies’ offerings: Oracle used an ASCI character set while the IBM midrange and mainframe systems relied …

  Read more

• Guru: Putting Failure Handling In Its Place

  August 24, 2026 Gregory Simmons

  One of the things I enjoy most about procedure-driven RPG is that it encourages us to think about responsibility. Every procedure should have a clear purpose. It should perform one task well and leave unrelated concerns to other parts of the application.

  That sounds straightforward enough, yet one responsibility often finds its way into nearly every procedure we write: failure handling.

  If you have worked with RPG for any length of time, you have probably encountered applications where nearly every procedure begins with a MONITOR operation. The procedure performs its work, catches any exception that occurs, logs an error, returns …

  Read more

• Inside The Security Enhancements In ACS

  August 24, 2026 Alex Woodie

  Keeping track of IBM i configurations and how users are using IBM i is important for security purposes. But administrators and analysts are already so overburdened with other responsibilities that it is easy to let something slip by. That is why IBM is building new SQL capabilities into Access Client Solutions, which hopefully will make it easier for IBM i shops to spot potentially damaging configs or uses before they hurt the organization.

  ACS is one of the most important tools provided by IBM for IBM i professionals, as it contains a slew of facilities for interacting with the system. …

  Read more

• Guru: Claude’s SQL Tip

  August 10, 2026 Ted Holt

  Today’s tip comes to us from Claude, as in the AI chatbot created by Anthropic. I don’t need to introduce him. Many readers of this august publication are far better acquainted with him than I am. I have heard reports of IBM i programmers who have quit writing source code, telling Claude to write it for them. Some folks seem to be right proud of that fact. Furthermore, I’m told that some places no longer allow humans to write source code.

  I had a few ideas in mind for this article and was weighing the merits of each one when …

  Read more

• Astera Makes Extracting Legacy Report Data an AI Specialty

  August 10, 2026 Alex Woodie

  For all that large language models (LLMs) are really good at – and they are great at a few things – understanding large reports generated by IBM i servers and System Z mainframes is not one of them. A Southern California company called Astera has identified this gap and developed its own AI-based tool for extracting information from this valuable resource.

  Foundation AI models and LLMs are probabilistic systems, and they work best in the gray zones: Inputting words and images, and outputting other words and images that are similar to the originals that it was trained on but not …

  Read more

• Guru: Beyond Three-Part Naming – Running SQL Across Remote IBM i Systems

  August 3, 2026 Gregory Simmons

  In my article Guru: Finding Data in The Forest – Exploring Three-Part Naming In SQL, I helped you to get started with three-part naming. If you have a network of IBM i systems and haven’t availed yourself of this capability, you may be surprised at just how powerful it can be. Instead of relying on data transfers, replication, or intermediate files, SQL can reach directly into remote systems as though the data were local.

  That works well when you know exactly which remote system contains the data you need. But what happens when your network grows from a handful …

  Read more

• How IBM Bolstered IBM i Resilience In The Summer Tech Refreshes

  August 3, 2026 Alex Woodie

  The capability to weather disruptions is a hallmark of the IBM i platform and a major reason why so many companies around the world rely on it to run their businesses. To that end, IBM has enhanced the platform’s resilience capabilities as part of the recent Technology Refresh announcements with updates to Migrate While Active and the BRMS facility, as well as bringing a new VTL to IBM i.

  As mentioned in our first story about the 2026 Summer TRs, IBM has updated Migrate While Active, which it originally announced back in October 2024 as a variant of the …

  Read more

• What IBM’s Got Cooking In Db2 For i In The Summer TRs

  July 27, 2026 Alex Woodie

  Last week, IBM announced PTFs containing a slew of new Db2 for i features and enhancements as part of the Technology Refresh for IBM i 7.6 and 7.5. While the database is just a part of the story for IBM i 7.6 TR2 and 7.5 TR8, it’s a critical piece of the puzzle. Here’s a preview of the new stuff that you can now play with.

  As part of the summer TRs that we covered last week, IBM delivered five functional enhancements to Db2 for i as part of the Summer TR, shipped one security enhancement, one enhancement for …

  Read more

• Big Blue Finally Unveils First IBM i Tech Refreshes Of 2026

  July 20, 2026 Alex Woodie

  Well, that took a little longer than usual. Last week, IBM finally made its first IBM i Technology Refresh announcements of 2026, formally unveiling the group of updates that collectively will make up IBM i 7.6 TR2 and 7.5 TR8. With the fall TR ostensibly just three months away, the good news with the two new TRs is that the general availability date is this Friday.

  Since IBM moved to the TR cycle back in 2010, it has traditionally given the IBM i community two big updates per year, one in the spring (normally April) and one in the …

  Read more

Previous Articles