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

How to delete first few rows from a file with IBM i SQL This morning I was working with a flatfile import from IFS into a DB2 database file. This should have been straight forward but the flat file contained several rows of crappy data at the start of the file. *ugh* Since I am

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

Short expressions – simple math expressions (+ = …) : Is A=A+1 the same as A += 1 ? The short answer is YES If you are an old style RPG programmer, evolving into a modern RPG programmer you will frequently see this style of coding when looking at modern RPGLE code examples: $variable +=

Read More