Not dying users, you big silly! Are your IBM i Users Passwords Expiring? Every IBM i User Profile can be created with an automatic expiration date set against it. This forces regular password changes. So, how do we find out how many IBM i User Profiles with passwords set to expire are rapidly approaching a

Read More

IBM i User Information is easy with SQL USER_INFO If you’re working with IBM i and need to retrieve information about user profiles, you can use the USER_INFO view. This view provides details about various aspects of user profiles. Here are some key columns from the USER_INFO view: You can query this view using SQL

Read More

What is an RPG language HELLO WORLD program? A “Hello, World!” program is a simple computer program that outputs or displays the iconic phrase “Hello, World!” to a user. This humble program serves as a fundamental introduction to programming languages and illustrates their basic syntax. Let’s explore this tradition further: The “Hello, World!” program typically

Read More

Following on from the previous blog, lets have a play with the PASE environment and install Node.JS Step 1: PASE from the IBM i Command Line From your IBM i 5250 session call the PASE program to enter the environment: Alternatively, you can initiate a terminal session using Powershell, PuTTY, VSCode Terminal, Git Bash, or

Read More

How can we Lockdown SQL Access for IBM i Users? Administrators often want to limit what SQL statements a user is allowed to run because how powerful SQL can be. What’s Different about SQL? SQL is a separate interface to the data and runtime SQL is part of the basic operating system. SQL uses the

Read More

What is NodeJS and does it work on my IBM i System? Node.js is an open-source project based on the Google Chrome JavaScript Engine. It provides a platform for server-side JavaScript applications that can run without browsers. Developers often choose Node.js for real-time applications due to its event-driven architecture and non-blocking I/O API. The IBM i platform supports Node.js, allowing it

Read More

SHORTCUTS for VS Code for IBM i Recently, I’ve been using the wonderful Visual Studio code editor with CODE 4 IBM i a lot. After ditching IBM RDi, I’ve found myself constantly referring to the VSCODE cheat sheet to learn the many keyboard shortcuts. So, just for my reference (and maybe to help someone else

Read More

IBM i ACS (1.1.9.4) was recently released and has some good new stuff! IBM i Access Client Solutions (ACS) is a software package that provides a platform-independent interface to IBM i systems. The latest version of IBM i ACS is 1.1.9.4, which was released in November 2023. This version includes several enhancements and critical security

Read More

One IBM i IDE to Rule them All IBM has released a seemingly innocuous update to IBM Rational Developer for IBM i. The new version, V9.8, is built over the latest version of eclipse and looks and feels the same as the previous (v9.6) version of RDi but is slightly faster. Sadly, it’s also HUGELY

Read More

It’s time to move MOVE out of old RPG Programs One of the biggest mistakes I’ve made while trying to modernise old RPG code, is simply importing the old code and trying to take the whole thing as one lump upgrade to modern RPG ILE. Hindsight is 2020, and something I’ve learned from the many

Read More

IBM i HTTP Web Server Authentication using an IBM i User Profile and Password We tend to think of consuming a webservice (“connecting and reading from a webservice”) as something that is open to the public. But what if we want to add an extra level of authentication? How about we force the connection to

Read More

Serve JSON Web Services with RPG and YAJL aka — Access data running on other computers with REST and JSON This is a ressurection of an old article which was lost from the internet when iPro Developer died. Luckily I found an old PDF printout and dutifully copy/pastedf all the text. Thanks to Scott Klement

Read More