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

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

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

The Winner is Visual Studio Code Visual Studio Code is an IDE (Interactive Development Environment). It’s a modern coding tool helping software developers to work with many languages. To write and maintain source code on your IBM i, iSeries or AS400 system, simply download and install the ‘Code for IBM i’ addon. Visual Studio Code

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