• Oft-Requested SQL Function Coming In IBM i 7.6

  April 8, 2025 Alex Woodie

  IBM i engineers and product managers have no shortage of feature requests to wade through, some of which make it into the platform and many of which do not. With the upcoming delivery of IBM i 7.6, IBM will be delivering one of the most often requested features: Support for UPDATE and DELETE statements in the data-change-table-reference clause of a SQL statement.

  While the capability to update and delete statements with data-change-table-reference may not sound like a big deal, it actually represents a significant improvement that will simplify database programming tasks for developers, according to Scott Forstie, IBM’s Db2 for …

  Read more

• The Top Ten IBM i Requests From The IBM Ideas Portal

  April 2, 2025 Alex Woodie

  Big Blue is gearing up for a major new release of the IBM i operating system. We don’t know yet what will be in the release, but we can forge some guesses by checking out what new features the IBM i community is requesting through the IBM Ideas portal, and how IBM reacts to them.

  IBM prides itself on being a customer-focused organization, and so it looks to the IBM i community for direction on what sort of features, capabilities, and fixes the IBM i community currently is looking for. That community outreach takes various forms, including the COMMON Americas …

  Read more

• Is IBM i Ready for the Agentic AI Revolution?

  March 24, 2025 Alex Woodie

  The AI world moves fast. Just when you get your head around large language models (LLMs) and the chatbots and coding co-pilots they enable, the AI world has moved onto something new. In 2025, that something new is the reasoning model, which is enabling autonomous AI agents and the world of agentic AI.

  Is IBM i ready for the revolution that’s about to unfold?

  By now you have undoubtedly read about LLMs such as OpenAI’s ChatGPT, Google’s Gemini, and Meta’s Llama. These LLMs are popular ways to power text-based generative AI applications, such as chatbots, coding co-pilots, and question-and-answer …

  Read more

• Fresche Makes Moves In The Cloud

  March 24, 2025 Alex Woodie

  Fresche Solutions is well known for IBM i application modernization, a line of business in which it has been successful for many decades. Thanks to its acquisition of OmniData Insights and a new partnership with IBM, the company is launching new ventures in the cloud.

  In early March, Fresche Solutions announced a partnership with IBM that will see Fresche managing IBM Power Virtual Server (PowerVS) customers. PowerVS is IBM’s cloud offering, and gives customers the capability to run IBM i, AIX, or Linux operating systems either in IBM datacenters or its partners’ datacenters. The deal with IBM means that Fresche …

  Read more

• Guru: Creating An RPG Stored Procedure That Returns A Result Set

  March 17, 2025 Mike Larsen

  In the previous article, I showed how to create an RPG stored procedure that uses parameters. In this article, I’m going to show how to create an RPG stored procedure that returns a result set, as we would likely encounter this scenario more frequently. The data used in this example comes from the Department table from IBM’s Sample database.

  I created an RPG program (Figure 1) that selects all rows from the Departments table. I didn’t add any selection criteria as I know there aren’t many rows in the table, but you may want to limit the number of rows …

  Read more

• Rocket CDC Tool Pushes Data Out Of IBM i

  March 10, 2025 Alex Woodie

  IBM i shops that need a change data capture (CDC) tool to push Db2 data off the box onto a target system, such as an Apache Kafka stream, may want to check out the new DataEdge product that Rocket Software recently announced.

  In late January, Rocket Software unveiled DataEdge, a new suite that provides a spectrum of data integration, data discovery, and data virtualization capabilities under the specific product names Rocket Data Replicate & Sync, Rocket Data Intelligence, and Rocket Data Virtualization. Some of the components in DataEdge are preexisting, while others – such as the outbound IBM i CDC …

  Read more

• Guru: AI Pair Programming In RPG With GitHub Copilot

  February 17, 2025 Gregory Simmons

  If you have been meaning to give VS Code a try, but just haven’t had a chance, I encourage you to avail yourself today. Yes, for you RDi users, it will take a little bit to migrate your favorite settings, code snippets, and compile commands – but I promise, you won’t regret the move.

  In my article, Getting Started With The Code 4 i Extension Within VS Code, I offer a few more insights to help get you started. And if you are an SEU user, yes, the switch may seem daunting, but one of the great things about …

  Read more

• ARCAD Discover: Global Application Analysis With An AI Interface

  February 10, 2025 Michel Mouchon

  Here is a simple test to reckon the value of the applications that run your company. Walk down to the datacenter, or over to the datacloset, or SSH out to the cloud, and turn the physical or logical machine running those applications off. What happens next?

  Aside from a lot of animated conversations and possibly some cursing, not much until you turn the machine back on and the system, databases, and applications reboot. You already knew this, but now everyone else has discovered, rather suddenly, how the very existence of the business and the livelihoods of the employees is dependent …

  Read more

• What Do IBM i Shops Use To Write Applications These Days?

  February 3, 2025 Alex Woodie

  When it comes to languages and tools for developing applications on IBM i, there are a ton of options available for customers. Thanks to the PASE runtime, a variety of open source languages and runtimes have been brought to the platform, not to mention the time-tested ILE technologies from IBM. But what do IBM i shops actually use to write new apps? For answers, we look to Fortra’s 2025 IBM i Marketplace Survey results.

  Fortra recently released the results for the 11th installment of its IBM i Marketplace Survey, which is based on surveys it conducted in late 2025 …

  Read more

• 2025 IBM i Predictions, Part Three

  January 27, 2025 Alex Woodie

  What will happen this year in the little neck of the IT wood that we call the IBM i community? It’s hard to say for sure, but one thing is certain: It sure a lot of fun guessing what might happen or what could happen! And who knows? Some of these predictions may actually come true.

  After 20 years with IBM i software vendor PKS Software, Heidi Schmidt has seen a thing or two in the midrange. There have been many ups and downs over the years, and a wide array of names. But Schmidt is bullish that the …

  Read more

Previous Articles Next Articles