Another work week comes to an end. Another week when an executive asked “I’ve heard both names, do we have an iSeries or an AS400?” Another work week, where I had to gently explain, “We have an IBM POWER SYSTEM, running an operating system called IBM i.” Another work week, where I had to follow …

Read More

SQLRPGLE Shorts – How to Call QCMDEXC with IBM i SQL Surely every RPG programmer is familiar with the QCMDEXC *API for exciting any IBM i Command from within any HLL (High Level Language) program. What is QCMDEXC? The Execute Command (QCMDEXC) API runs a single command. It is used to run a command from …

Read More

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

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

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

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

How to Substring a Packed numeric in a Logical File So – you have a Physical file and you want to create a logical with substrings of file data or maybe concatenation of the same data. “That’s easy” I can hear you think… but… but… what if you need to do this with a substring …

Read More

Every propeller head takes some kind of perverse joy from wiping and reinstalling their Windows Machine. I know I do. After a year of various software installs, un-installs, re-installs, tweaks, hacks, dicking around (that’s a technical term) my Windows machine starts to get twitchy and a little punch drunk. It’s time for a fresh install and …

Read More

Infor (JBA) System 21? A recruiter asked me if I had heard of INFOR System21, because he had found an old blog talking about JBA and JBA System21. He wondered if they were similar applications. The Answer is YES: System 21 is an ERP – Enterprise Resource Planning solution. System/21 ERP was originally written by …

Read More