• 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

• How ERP Giants Are Building GenAI Into Their Products

  December 9, 2024 Alex Woodie

  We are still near the top of Gartner’s hype curve when it comes to generative AI. Larger companies that have discipline and money, and startups with time and ambition, are finding success with GenAI, but many organizations are still in the planning and roll-out phase. The same could be said for ERP vendors, who have started their GenAI journeys but are expected to ramp up adoption significantly in the years to come.

  Since the dawn of the mainframe age, computers have automated the work that was previously done by people. Large armies of file clerks were no longer needed once …

  Read more

• 2024: An IBM i Year In Review

  December 4, 2024 Alex Woodie

  It’s hard to believe that yet another year is coming to a close. As 2024 rolls to its merciful end, it’s time for us to take stock of the major events and announcements that impacted the IBM i community.

  January

  News broke in late January that revenue in IBM’s Power Systems business grew for the second year in a row in 2023. TPM’s model showed $1.53 billion in external Power Systems sales for the year, which was a hair above the 2022 figure, which was a hair above the 2021 figure. It’s not 2010-era numbers, when the figure was north …

  Read more

• IBM’s Fall 2024 Code for IBM i Enhancements

  November 13, 2024 Alex Woodie

  Adoption of Code for i continues to soar among IBM i developers, as they shift from heavy, expensive integrated development environments (IDEs) to lighter, open-source options. With the latest Technology Refreshes (TRs) for IBM i, IBM is making the VS Code plug-in even more useful for RPG and COBOL developers.

  Code for IBM i is the brainchild of Liam Allan, the midrange wunderkind with an intense aversion to Rational Developer for IBM i (RDi), IBM’s Java-based flagship IDE for IBM i. As adoption of the VS Code extension grew in the summer of 2022, IBM smartly hired Allan as a …

  Read more

• Another GenAI-Powered Testing Tool Comes to IBM i

  November 6, 2024 Alex Woodie

  IBM says it’s bringing a new AI accelerator to the Power line to drive compute-hungry generative AI workloads, such as the new RPG coding assistant that it’s also developing. But IBM won’t be the only source of such GenAI-powered coding assistants, as a company called Abstracta recently announced another one.

  There’s a lot of interest in the Spyre accelerators that IBM announced earlier this year for the System z mainframe and which IBM announced last month during its TechExchange conference will be coming to Power. Considering the massive demand for Nvidia GPUs, which could plug into past generations of Power …

  Read more

Previous Articles Next Articles