• New DbToo SDK Hooks RPG And Db2 For i To External Services

  August 25, 2025 Alex Woodie

  A team of open source developers led by IBM’s Jesse Gorzinski have developed an experimental new software development kit (SDK) designed to integrate RPG applications and Db2 for i data with external services. The SDK, dubbed DbToo, initially targets watsonx, Ollama, OpenAI endpoints, Kafka, Slack, and Twilio, providing another option for integrating IBM i with popular AI models and messaging services.

  The mainstream IT world is currently evolving at a tremendous pace, largely driven by open source big data projects as well as large language models (LLMs) that promise to automate a range of functions currently performed by humans. The …

  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

• Maxis Adds IBM i Support To Database Modernization Tool

  July 21, 2025 Alex Woodie

  Legacy applications are frequent targets for modernization efforts, but databases also need their share of TLC. One company that specializes in database modernization, Maxis Technology, recently announced support for IBM i and its integrated Db2 for i database with its flagship product, dubbed Alchemize.

  Maxis Technology is an Eagle Rock, Missouri, company that specializes in database modernization. Founded by Steve Cornell in 2011, Maxis develops the Alchemize database power tool, which allows developers and engineers to automate a range of database tasks, including: data migration and loading; data mapping and archiving; data transformations and cleanup; fixing data quality issues; optimizing …

  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

• 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

• 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

• RISE For SAP Could Be A Boon For IBM’s PowerVS Cloud

  March 17, 2025 Timothy Prickett Morgan

  German application giant System Analyse Programmentwicklung, better known as SAP, has spent more than five decades to deliver five major versions of application software to help companies run themselves. They are R/1 in 1977, R/2 in 1981, R/3 in 1992, mySAP.com (which became Business Suite) in 1999, SAP HANA in 2011 with its S/4HANA application suite in 2015. And today, the company has over 400,000 customers.

  As is well known, SAP wants to create an application system, which is a phrase that resonates with the OS/400 and IBM i faithful. SAP was founded by five ex-IBMers from Germany and started …

  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

• Security Top of Mind as Massive Hacks Continue

  December 4, 2024 Alex Woodie

  The calendar indicates peace and joy, but instead a sense of dread and fear permeates business, as the number and scope of security breaches grows and new regulations loom on the horizon. Ransomware, in particular, is proving itself to be a thorny issue for companies of all sizes, including IBM i shops.

  The latest mega-hack involved Chinse state actors infiltrating the American telecommunications backbone, where they not only accessed huge numbers of call detail records (CDRs) – which they used for counter-espionage purposes – but also read text messages and listened to Americans’ phone calls.

  Known as Salt Typhoon, the …

  Read more

Previous Articles