If you’re an IBM i developer, admin, or general green‑screen wrangler, you already know that IBM i Access Client Solutions (ACS) is the Swiss Army knife we all rely on. It’s the tool that quietly does everything: 5250 emulation, SQL scripting, file transfers, database navigation, and the occasional “why is this button even here?” mystery …

Read More

How to Check Whether a Subsystem Is Active in IBM i Using CL If you’ve spent any time automating operations on IBM i, you’ve probably bumped into this classic requirement: “Before I run this job, I need to know whether a subsystem is active.” It sounds simple, but depending on your tooling and IBM i …

Read More

Every IBM i developer has opened a source member, stared at a sea of cryptic variable names, and muttered something unprintable. We have all inherited codebases where X1, CUSTFLG, and TMP123 roam free like wild animals. And while that might have been acceptable in the 1980s, modern RPGLE deserves modern readability. A clean naming convention …

Read More

If you’re an IBM i administrator, developer, or power user, IBM i Access Client Solutions (ACS) is likely your go-to tool for everything from 5250 emulation to database management, Run SQL Scripts, and IFS browsing. But ACS is a Java application at its core, which means your experience, and security, hinges on the Java Runtime …

Read More

If you’re still storing all your RPG, CL, and SQL source in traditional QSYS libraries, you’re missing out on one of the biggest productivity boosts available on IBM i today. The Integrated File System (IFS) is no longer just “that Unix-like thing over there” it’s the natural home for modern IBM i Source Code. Twenty …

Read More

If you’ve ever stared at a wall of fixed-format RPG code and thought, “This looks like it was written by a medieval monk with a ruler and quill,” then welcome to my world. I’ve spent far too many hours squinting at columns, indicators, and op codes that look like they were designed to test patience …

Read More

Welcome to the latest chapter of my IBM i RPGLE Operation Codes Guide. In my ongoing mission to document and clarify the wonderful IBM RPGLE language for new programmers, students and established old-school programmers looking for new styles of code (who says old dogs cant learn new tricks?!) I’m taking the IBM RPG Operation Codes …

Read More

I was in a meeting with a client earlier today – they were discussing hardware changes, software version control, promotion flow and how to set TURNOVER ALM up. A mix of folks in attendance; a couple of current IBM-i programmers, some old AS400 techies and a host of vocal application managers, with everyone seemingly confused …

Read More

I’ve spent decades wrangling RPG code on AS400, iSERIES and IBM i systems. You know the drill: endless source files, green screens, and that nagging pull to modernize without breaking everything. Very repetetive and prone to broken code because of a finger slip, a mistyped line of code or a fat-finger moment on the keyboard. …

Read More

If you are working with stored procedures on your IBM i system, you know they are handy for encapsulating business logic and making your SQL calls more efficient. But what happens when you need to back them up or restore them after a hiccup? Today, I am walking you through the process in a straightforward …

Read More

Once upon a time in a land of legacy systems and mystical green screens, brave programmers roamed freely with passwords like “123456” and “PASSWORD1.” But then came the prophecy: “Thou shalt not allow weak credentials to guard thy sacred data.” And thus began the quest to enforce secure IBM i passwords. Or did it? Well… …

Read More

IBM i SQL Stored Procedures are the King of the IBM i Database Jungle Welcome to a deep dive into the world of database management! Today, we’re focusing on a powerful tool that can transform how you handle data: stored procedures. Whether you’re working with IBM i, SQL Server, or another database system, stored procedures …

Read More