Converting an old Physical File (PF) to a modern SQL table can significantly enhance your database’s functionality and performance. Here are the general steps to achieve this: Here’s a simple example of how you might convert a PF to an SQL table: Creating SQL TABLES is easy – so How do we convert old DDS

Read More

A while ago, I got this terrific email from a subscriber. I will call him “Nuno”. Not because that’s a pseudonym, but because that’s his name. Hi Nuno! So, lightly paraphrased this is what Nuno said to me: It warms my heart to get emails like this 🙂 I’ve been writing blogs on here for

Read More

In our clan of gray haired AS400 and iSERIES programmers, we all have roots in the good old RPG LOGIC CYCLE. We have one foot in the old world of huge programs with tens of thousands of lines written in a very start-middle-end style, often with many subroutines. The other foot is in the modern

Read More

SPOILER ALERT: It is NOT! The IBM AS400 was a groundbreaking computer system. First released in 1988 it quickly became the business system of choice for millions of companies all over the world. The AS400 was released to a pre-internet civilization, it grew and evolved as technology was introduced through the eighties, nineties and into

Read More

What is an IBM i PATH? In PASE (Portable Application Solutions Environment), $PATH is an environment variable that stores a list of directories where the system searches for executable files, such as commands and programs. The PATH is like a *LIBL for open source. Just like library lists, the PATH setting only exists during our

Read More

What is an RPG language HELLO WORLD program? A “Hello, World!” program is a simple computer program that outputs or displays the iconic phrase “Hello, World!” to a user. This humble program serves as a fundamental introduction to programming languages and illustrates their basic syntax. Let’s explore this tradition further: The “Hello, World!” program typically

Read More

AI is getting clever. I’m honestly not too sure that AI is a good thing. We all watched the Terminator movies, right? But that being said, I like to use the Microsoft’s COPILOT AI, because it makes collating answers to questions so very simple. It certainly makes researching answers to quick questions just about a

Read More

SHORTCUTS for VS Code for IBM i Recently, I’ve been using the wonderful Visual Studio code editor with CODE 4 IBM i a lot. After ditching IBM RDi, I’ve found myself constantly referring to the VSCODE cheat sheet to learn the many keyboard shortcuts. So, just for my reference (and maybe to help someone else

Read More

One IBM i IDE to Rule them All IBM has released a seemingly innocuous update to IBM Rational Developer for IBM i. The new version, V9.8, is built over the latest version of eclipse and looks and feels the same as the previous (v9.6) version of RDi but is slightly faster. Sadly, it’s also HUGELY

Read More

It’s time to move MOVE out of old RPG Programs One of the biggest mistakes I’ve made while trying to modernise old RPG code, is simply importing the old code and trying to take the whole thing as one lump upgrade to modern RPG ILE. Hindsight is 2020, and something I’ve learned from the many

Read More

What is Node.js? Node.js is an open source project based on the Google Chrome JavaScript Engine. What does Node.js do? Node.js provides a platform for server-side JavaScript applications running without browsers. Who can use Node.js? Node.js can be run on the IBM i power system, a platform that provides enterprise-grade scalability and reliability for business

Read More

RPG Rules – aka – When Rulers helped you program A few years ago, moving house for the umpteenth time, I found my old RPG Ruler from way back in the day. I think this is from the late 1980’s when I was learning to program RPG2 and RPG3 on the first IBM Machine I

Read More