Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
IBM i, Programming, RPG, SQL
If you have ever written a tidy little subprocedure that does some embedded SQL, then checked SQLCODE afterwards only to find it stubbornly sitting at zero even though the statement clearly failed, you have probably met this gotcha. Today we are going to answer three questions that trip up plenty of IBM i developers: Spoiler: …
SQLRPGLE – A Sortable Subfile with Column Headings and Search using RTNCSRLOC If you have been following the subfile series, you will know we already have a solid working example in the SORTSFLBOB program. Now it is time to add the finishing touches that make it feel properly modern. Let’s go with the assumption that …
Code Modernization, Upgrading, Refactoring with an AI Coding Companion – Which to use? I have been playing with a little experiment this week and I thought I would share the results while they are still fresh. The star of the show is a classic little RPGLE subfile program I wrote years ago, it’s languished in …
A subscriber left a great comment on one of my recent vlogs. They’re worried that all this Node.js stuff that IBM is encouraging, means we’re opening up security holes! NPM Hackers caused a supply chain mess with Red Hat back in 2024, and now hundreds of packages with their own dependencies could be sitting on …
The 3am Wake-Up Call You Didn’t Need: Service Account Password Expiration If your web services or overnight batch jobs have ever thrown a wobbly because a password decided to expire at the worst possible moment, you are not alone. On IBM i systems, password expiration is one of those security features that works brilliantly for …
Mapepire on My IBM i System: Finally Database Connections That Dont Make Me Want to Scream into the Void! Picture this: you are building a slick modern app and you just want it to chat nicely with Db2 for i without wrestling ancient ODBC drivers or wrestling with client libraries that feel older than your …
