• AI Is Coming for ERP. How Will IBM i Respond?

  September 8, 2025 Alex Woodie

  A wave of artificial intelligence is beginning to wash over the enterprise resource planning software market, changing the nature of how businesses process automation gets done. IBM i has been a solid platform for running ERP systems for decades. But how will the new generation of AI-enabled enterprise apps get to IBM i?

  When it comes to automating business processes, ERP packages have been the primary means for achieving it for the past four decades. The big monolithic apps from SAP, Oracle, Infor, and dozens of others have driven trillions of dollars in value by providing a …

  Read more

• Big Blue Delivers IBM i Customer Requests In ACS Update

  August 25, 2025 Alex Woodie

  Christmas is still four months away, but that didn’t stop IBM from giving Access Client Solutions (ACS) customers the new features they requested. The deliveries were made in the mid-summer update, ACS version 1.1.9.9.

  ACS is the must-have tool that lives in every IBM i professional’s toolbox. It contains a slew of facilities for interacting with the system, including RSS, data transfer, IFS file viewing, spool file management, 5250 emulator, 5250 printer emulation, and a virtual console for LAN and HMC management.

  IBM updates ACS several times a year regardless of the Technology Refresh cycle, as is typical with several …

  Read more

• Guru: Decoding Base64 ASCII

  August 18, 2025 Chris Ringer

  A co-worker of mine recently asked me how to decode a base64 ASCII string in RPG, received from an HTTP response. My response was “that’s easy”, simply use the relevant SQL function BASE64_DECODE. I promptly wrote some sample code and after some debugging I realized this function threw me a curveball.

  Let me demonstrate the issue and offer a simple solution.

  01 **Free
  02 ctl-opt DftActGrp(*No) Copyright('(C) Chris Ringer');
  
  03 dcl-s string_UTF8   varchar(1000) ccsid(*UTF8);
  04 dcl-s base64_UTF8   varchar(1350) ccsid(*UTF8);
  05 dcl-s decoded_UTF8  varchar(1000) ccsid(*UTF8);
  06 dcl-s decoded_Hex   varchar(1000) ccsid(*HEX);
  
  07 Exec SQL Set Option Commit=*NONE, Naming=*SYS;
  08 string_UTF8 = 

  …

  Read more

• You Can Now Get IBM Tech Support For VS Code For i

  August 11, 2025 Alex Woodie

  IBM i shops that were on the fence about migrating from Rational Developer for i and adopting VS Code for RPG and COBOL development just received one big reason why they should bite the bullet and make the move: the launch of a new technical support package for Code for i from IBM.

  Visual Studio Code is currently the most popular integrated development environment (IDE) on planet Earth, according to multiple measures, such as the Stack Overflow’s 2025 Developer Survey, which found Microsoft VS Code was used by 76 percent of all respondents, more than twice the usage of …

  Read more

• Profound Logic Adds MCP To IBM i AI Tool

  July 28, 2025 Alex Woodie

  The world of AI is moving extremely fast right now, with new models, techniques, and technologies emerging every week. One of the newest bits of AI tech to catch on is Anthropic’s Model Context Protocol (MCP), which has quickly become a defacto standard for connecting data sources to AI models. Profound Logic, which has been on the cutting edge of AI, is the first IBM i vendor to bring MCP support to the server and the Db2 for i database.

  Anthropic quietly launched Model Context Protocol in late November 2024 as a way to enable large language models (LLMs), such …

  Read more

• Liam Allan Shares What’s Coming Next With Code For IBM i

  June 23, 2025 Alex Woodie

  The rise of Code for IBM i arguably is the best IBM i technology story of the past few years. The VS Code development environment came out of nowhere to challenge Rational Developer for i as the pre-eminent developer tool on the platform. And according to Liam Allan, who started this whole thing, Code for i is only going to get better in the months and years to come.

  There is clear and unmistakable momentum behind VS Code and Code for IBM i, the VS Code plug-in that Liam Allan created back in 2021 while working at Seiden Group …

  Read more

• Meet The Next Gen Of IBMers Helping To Build IBM i

  June 16, 2025 Alex Woodie

  The graying of the IBM i installed base is a topic that deserves attention, as every platform must find a way to reinvent itself if it wants to survive. IBM executives have been vocal about the need for IBM i customers to hire younger people. Well, it looks like Big Blue is taking its own advice, judging from the new crop of developers working in the Rochester and Toronto labs, and beyond.

  It’s hard to believe that Liam Allan has been working on the IBM i platform for nearly a decade. Allan, who started working on IBM i when he …

  Read more

• RPG Code Generation And The Agentic Future Of IBM i

  June 2, 2025 Alex Woodie

  IBM is making progress with Watsonx Code Assistant for i, which is on track to become available as a public preview next month. And while IBM perhaps is running into some challenges with generating RPG code, the long-term potential of agentic AI on IBM i is brighter than ever.

  As we previously reported, IBM is now taking names for the folks who will be given access to the public preview of WCA for i, which you can sign up for here. According to IBM i CTO Steve Will, the preview will deliver RPG code understanding capabilities, which is …

  Read more

• Public Preview For Watson Code Assistant for i Available Soon

  May 21, 2025 Alex Woodie

  At the COMMON POWERUp 2025 conference this week, IBM pulled the covers back a bit on Watson Code Assistant for IBM i, the new name for the AI-powered coding assistant that IBM first started talking about one year ago. A public preview of WCA for i is becoming available to a limited number of testers, with general availability expected in the second half of the year.

  There has been quite a bit of development in the IBM i coding co-pilot this month. On May 7, during the IBM Think conference, two IBM executives wrote a blog post announcing WCA for …

  Read more

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

  May 12, 2025 Mike Larsen

  Continuing to build out the stored procedure series, I’m going to show how to create an SQL stored procedure that returns a result set. This is very similar to the previous article where I showed how to do this using RPG. In this example, we’re just using pure SQL to achieve the same results.

  I created an SQL script (Figure 1) that selects all rows from the Departments table. The SQL statement is the same as the one I used in the RPG program from the prior article, but I’ll describe it again here. I didn’t add any selection criteria …

  Read more

Previous Articles Next Articles