PDM (Programming development manager) is installed as a part of the Applications Development ToolSet (ADT) on most IBM i systems today. PDM is an environment that lets programmers and/or operators easily navigate and work with objects in libraries (aka schemas) anywhere on their IBM i Power Systems. PDM enables users to utilize shortcuts for executing repetitive tasks. Frmo

Read More

If you have read any of my previous blogs about IBM i Programming, the chances are, you know I’m becoming a bit of a VS-Code fanboy… or maybe Fanman… well… probably fangeezer is most accurate. Over the last couple of months, we’ve seen some really neat updates to the Code for IBM i and other

Read More

Green Screen Signon in a Webpage IBM i Access for Web revolutionizes your Boss’s view of your IBM i systems, offering a stretchy, secure, and user-friendly web gateway to those oh-so-important resources. Want to give your IBM i a fresh coat of modern? This tool just might be your ticket to the future! I know

Read More

Mastering Git on the IBM i: It’s not as hard as you might think! As an IBM i developer, you’re likely familiar with the traditional source control tools available on the platform, such as PDM, SEU and Third party tools like TURNOVER, ALDON, etc. While these tools have served the IBM i community well, the

Read More

Interviews are a worrying time for most people, right? Not for me! I really enjoy them. But, with 30+ years of experience under my belt, I have a very comfortable time talking about all aspects of the wonderful IBM POWER SYSTEM and the IBM i OPERATING SYSTEM. I know maybe half of the operating system

Read More

Why should I learn about webservers on the IBM i System? Do you ever lay in bed asking yourself that question? I used to. But, now I know how to create various types of webservers, so instead I lay in bed asking myself more annoying questions like “Why is my webservice not able to read

Read More

So, you’ve got IBM i Access Client Solutions (ACS) on your system, and it’s as reliable as a trusty old pickup truck. But maybe it’s time to give that truck a new paint job or a fancy set of hubcaps, metaphorically speaking of course! Customizing ACS isn’t just about making it work better; it’s about

Read More

IBM i Housekeeping 101 – Deleting old Journal Receivers Following on from the blog I wrote about “What is an IBM i Journal?“ We know that IBM i journals record what happens to files, and we know that this record is kept in these things called journal receivers. What is a Journal Receiver? An IBMi

Read More

IBM i Journals are the Sherlock Holmes of data storage. IBM i Journal keeps a log of events, just like your Diary. Imagine writing down every single thing that happened to you during the day. This is what a journal does for any file on the system. Me – trying to explain what a journal

Read More

Come with me while I go on a journey of discovery setting sail from the land of Legacy AS400 coding techniques, sailing over the horizon in search of the future of IBM i Coding Techniques. The mission is to migrate away from green screen, also known as command line interface, and leave the old trusty

Read More

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

Playing with SQL on the IBM i System: IBM-i Aggregate Functions In the world of data management, SQL (Structured Query Language) stands out as a powerful tool for querying and manipulating databases. Among its many features, aggregate functions are some of the most valuable yet often underutilized capabilities. These functions allow you to perform calculations

Read More