Using the same AS400 QRY in Dev, Test and Prod I had a good question from a subscriber today: We have a production environment and a test environment on our IBM i. We have processes in place to switch library lists depending on which environment we are in. We have issues where our test side

Read More

It’s time to install MariaDB on IBM i Following Part 1 – let’s dive into installing the actual thing and wade through any problems we see along the way. … Me – with a coffee MariaDB is a replacement for MySQL MariaDB is a fast, open-source, community developed branch of MySQL. Internal commands use the

Read More

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

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

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

Java isn’t free anymore? Last year, Oracle (the owners of Java) announced they were introducing a new chargeable structure to monetize their hugely adopted JAVA programming environment. So, now using Java Software means you may need to pay for a license! However, if you are using IBM software (like RDi) it comes bundled with a

Read More

JSON vs XML vs CSV These acronyms can sound like an alien language to people learning to become programmers and especially to established old-school green screen programmers (with the greatest respect to my AS400 and iSeries colleagues) Don’t worry – all these new terms can be totally baffling! Let’s break them down into simple explanations:

Read More

AS400 Client Access is dead – long live IBM i ACS (Access Client Solutions) also known as: Who killed AS400 Client Access? Ask any AS400 programmer, iSeries Developer or IBM i Nerd and they will all tell you that good old “Client Access” is a pain in the arse! Client Access was introduced back in

Read More