Count with SQLRPGLE Variable File Name Been having fun with SQL and RPGLE 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 incrementing

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 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

The State of AS400 iSeries Application Modernization Typically our aging AS400 and Iseries applications are stateful. So, if we are looking at iSeries application modernization, is it a mistake to try and simply modernize beautify them retaining their stateful flow, or should we be looking at refactoring them in a stateless direction? Is it really

Read More

Pattern Recognition: Ease Modern RPG Programming This morning I was reviewing the IBM i Redbook on application modernization, converting this massive PDF into an easy readable TOPIC based format in my AS400 and iSeries modernization course. I found a couple of problems with the internet. Yep, the internet is broken. The ebook has a couple

Read More

Rules for good coding style I started this with the idea of writing a blog about “Rules for good RPG coding style”, I was discussing this with an old friend and colleague yesterday. He moved away from the AS400 machine, just as it was being replaced with the old iSeries machine. He’s now spent nearly

Read More

Firewalls – Ports – TCP/IP Three words that strike fear into most IBM i programmers. General Use — Green screen emulator, ftp, file sharing etc. On the IBM i System, most of the host servers can be configured for SSL by using the Digital Certificate Manager (DCM) to assign a certificate to that individual server.

Read More

AS400 DLS vs. IBM i IFS Do you work at a company that has people using the AS400 DLS? Do you work at a company with techies talking about the iSeries DLS? Do you work at a company that uses the IFS and the DLS? Are you confused about if your business server is an

Read More

What is the Best IBM i RPG Code Editor in 2021 Most people migrated from SEU to RDi (Rational Developer) But there are other code editor choices out there, so let’s have a look at a few different options: What is the best FREE RPG Code Editor? What is the best PREMIUM RPG Editor? What

Read More

Home Exchange is pretty pretty pretty good Seriously – you can travel the world, swapping your home with some else’s for nothing! You can exchange your home for your next vacation and have an unforgettable travel experience. With more than 450,000 homes in 187 countries, HomeExchange is the world leader in home exchange vacations. Discover

Read More

The Internet is a wealth of facts, fictions, opinions, lies, and halftruths! This thing called the internet has lots of information, lots of misinformation, lots of good guys, and lots of bad guys in it. Just like the human society we live in. In real life, we read signals of danger from how people look,

Read More