Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
Who’s Got the Keys to the IBM i Kingdom? Come with me on a hunt for *ALLOBJ Profiles Picture this: you’re the sheriff of your IBM i system, tasked with guarding the kingdom from rogue profiles wielding the ultimate power… that super *ALLOBJ special authority. This is the kind of power that lets someone rearrange …
Securing Your IBM i System with WRKSYSVAL SYSVAL(*SEC) If you are like me, always tinkering with your Power Systems box to keep it locked down tight, then you need to get familiar with the WRKSYSVAL command. Specifically, using it with the SYSVAL(*SEC) parameter. This little gem is your gateway to tweaking the core security settings …
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 …
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 …
AI is getting clever. I’m honestly not too sure that AI is a good thing. We all watched the Terminator movies, right? But that being said, I like to use the Microsoft’s COPILOT AI, because it makes collating answers to questions so very simple. It certainly makes researching answers to quick questions just about a …
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 …
IBM Tips on Cleaning Up QSPL Storage To manage and clean up QSPL storage on IBM i systems effectively, here are some best practices: IBM offers some great advice: By following these tips, you can help ensure that your IBM i system’s QSPL storage is managed efficiently and remains free of unnecessary clutter. Obviously, always …
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 …
The Reorganize Physical File Member (RGZPFM) command removes deleted records from (compresses) one member of a physical file in the database, and it optionally reorganizes that member. What we used to say about RGZPFM It is generally not recommended to perform an RGZPFM (Reorganize Physical File Member) operation on IBM i files while they are …
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 …
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 …
