As I like to tell IBM i clients: the goal isn’t to get rid of the AS/400 database. It’s to discover that you’ve actually been running one of the world’s best SQL databases all along. The Advantages of Modernizing an Old AS/400 Database to Modern SQL If you are still rocking physical files defined in

Read More

IBM i BOB v2.0 was released June 24, 2026 – just one day before my birthday! Coincidence? I don’t think so 😉 IBM BOB TWO is a major rebuild of IBM’s AI-powered development partner. It focuses on speed, agentic capabilities, and better enterprise workflows, with a dedicated Premium Package for i that brings IBM i-specific

Read More

I was just happily working away and VSCODE (and IBM BOB) popped up this message: “YIKES!!!” I thought. Yes. I do still think in 100 year old English language style… By Jove! But don’t worry, a quick search and I found this to ease my fears: So, simply uninstall the Source Orbit Extension and get

Read More

If you have ever written a tidy little subprocedure that does some embedded SQL, then checked SQLCODE afterwards only to find it stubbornly sitting at zero even though the statement clearly failed, you have probably met this gotcha. Today we are going to answer three questions that trip up plenty of IBM i developers: Spoiler:

Read More

SQLRPGLE – A Sortable Subfile with Column Headings and Search using RTNCSRLOC If you have been following the subfile series, you will know we already have a solid working example in the SORTSFLBOB program. Now it is time to add the finishing touches that make it feel properly modern. Let’s go with the assumption that

Read More

Code Modernization, Upgrading, Refactoring with an AI Coding Companion – Which to use? I have been playing with a little experiment this week and I thought I would share the results while they are still fresh. The star of the show is a classic little RPGLE subfile program I wrote years ago, it’s languished in

Read More

A subscriber left a great comment on one of my recent vlogs. They’re worried that all this Node.js stuff that IBM is encouraging, means we’re opening up security holes! NPM Hackers caused a supply chain mess with Red Hat back in 2024, and now hundreds of packages with their own dependencies could be sitting on

Read More

The 3am Wake-Up Call You Didn’t Need: Service Account Password Expiration If your web services or overnight batch jobs have ever thrown a wobbly because a password decided to expire at the worst possible moment, you are not alone. On IBM i systems, password expiration is one of those security features that works brilliantly for

Read More

Mapepire on My IBM i System: Finally Database Connections That Dont Make Me Want to Scream into the Void! Picture this: you are building a slick modern app and you just want it to chat nicely with Db2 for i without wrestling ancient ODBC drivers or wrestling with client libraries that feel older than your

Read More

Mapepire, a type of pit viper native to South America, is IBM’s new interface layer for IBM-i. Mapepire boasts a logo that’s arguably the best creation from Big Blue since the original IBM emblem. As for how to say it, IBM-i Mapepire GitHub says Mapepire is pronounced ‘mapəpɪə’ or ‘MAH-pup-ee’ which seems nonsense to me! I’ve

Read More

TOBi Builder MAKEi Fails with BLEUUURGH Error Code – A Quick Debugging Tale Hey there, fellow IBM i programmers. Today we’re diving into a real-world head-scratcher I hit while working with TOBi (the IBM i Object Builder) and its MAKEi component. If you’ve ever tried to compile from your local source copies and instead of

Read More

New to the IBM-i platform? Read on…Experienced IBM-i Admin? Don’t bother! If you’re still here, and you’ve powered through my previous post (10 Essential IBM i Commands Every Beginner Must Master) and you’re starting to feel more at home on the green screen, then it’s time to take a few more steps into the IBM-i

Read More