DSPF Indicator Command Keys in AS400 RPG (… and iSeries and IBM i obviously) Ever since my days at JBA, I’ve used the old-fashioned function key indicators to handle internal Function Keys selections, or Command Keys as they were known in the System/3x days. These PFKEY ranges from keys 1 through 24. Most programmers used

Read More

RE: Position of “AS/400 Lead” in NYC (Remote). I got this random email from a recruiter today: My initial feeling was this is a fake email trying to solicit people’s Curriculum Vitae for their database. But then I was tempted to email him back asking “Do you really mean AS400 Lead?” and perhaps helping them

Read More

This is less of a blog, and more of a memory nudger for me! I’ve just been looking at a temporary blip (aka outage) on a clients IBM i Metro Mirror instance. I’m no expert on Metro Mirror, so this journal/blog is to help keep it fresh and I’m sure I will reference back to

Read More

Change how Gutenberg looks when editing a page 1 – I like the WordPress Gutenberg Editor OK… OK…. I know there are two camps of people in the WordPress content editing world. There are those that like the new layout of the GUTENBERG editor with its block functions and, those that prefer the old tried

Read More

How to find the last IPL date on AS400, iSeries or IBM i System The easiest visual way – WRKJOB SCPF Using cmd WRKJOB SCPF from the command line shows you the SCPF job that starts at IPL time: Take option 1 to look at job attributes: This example shows the IPL date of 02/01/22

Read More

Stefan Kudla – Glancing at Software Development Over the last few weeks, I’ve been mentoring a young man by the name of Stefan Kudla. By mentoring I mean – helping him take his first steps into the wonderful world of programming, website design, application modernization and the zillion other fields within the programming universe. Many

Read More

How to get a JBA Supplier History by Country I was asked to build a spreadsheet showing “All purchase totals for all suppliers by year and include the supplier country code” A simple request – so I thought I would blog the process for those new programers out there or for anyone wanting to understand

Read More

What is the system part of IBM i Library List? SYS – System The System (SYS) portion is always at the top. This is typically the libraries containing operating system objects. You can add libraries to your JOB’s system portion using the CHGSYSLIBL command – NOTE THIS IS FOR YOUR JOB ONLY PRD – Product

Read More

IBMi Modernization The Challenge of AS400/ISERIES Application Modernization, Database SQL Conversion and Cloud Migration Regardless of where you are in the world and whenever you are reading this blog entry, 99.99% of AS400 and ISERIES applications are running on an IBM i Power System. The reason I saved a .01%, is because I know of

Read More

New (PROBLEMATIC) Watch – William Wood Valiant the Bronze Special Edition UPDATED JULY 2023 – After 2 years the watch has started leaking water into the casing. Discovered while swimming in my pool. So Sad. Even though the divers watch is under warranty, I’ve been told this doesn’t cover water leaks! For a dive watch

Read More

Count with SQLRPGLE Variable File Name Been having fun with SQL and RPG ILE this afternoon… the question was “How do I find out if and how many policies exist in one of the reservation files for a given customer code?” Obviously, we could write a little piece of RPGLE doing a READ LOOP and

Read More

What is VISUAL STUDIO CODE? Microsoft Visual Studio Code, “a free-editor that helps the programmer write code, helps in debugging and corrects the code using the intelli-sense method”: Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with

Read More