Why these weird IBM Date formats? Back in the good old days of single megabyte disks the size of a shoebox, when hard drives were called Winchester Drives and the only phones we used were actually used for making telephone calls, size was everything (insert slightly rude joke here). In the daily effort to shave …

Read More

Convert QUERY to IBM i SQL This week I be mainly…. working on a Casino System upgrade, dragging decades old code into the twenty first century. Old RPG3, RPG400, CLP programs and techniques using outdated OPNQRYF and QUERIES are fighting back tooth and nail. I love this schnizzle. 🙂 One of the techniques for upgrading/converting …

Read More

IBM i SQL to validate Email So, we have a customer master file that’s been around for years. Users have been keying in customer info and sometimes adding email addresses, sometimes not, sometimes entering nonsense, or even just text that says things like “this chap has no email so don’t email him”. Yes, it’s a …

Read More

HOW TO UPLOAD SAVF to IBM i Systems If you don’t use FTP anymore (or if FTP has been blocked by your network team) the easiest technique is to upload your SAVF to your IBM i’s Integrated File System and then copy it direct into a *SAVF — using IBM I Access Client Solutions. Launch …

Read More

How do you change file attributes such as size, file wait time, record wait time? Use the CHGPF command of course CHGPF (Change Physical File) lets you change the object attributes for a Physical File: Remember, the CHGPF lets you change many of the attributes of the physical file object – it does not change …

Read More

UPDATE 2021 – Version 1 of ILEditor used to be free! Sadly, Version 2 is out and it’s become a chargeable premium code editor. Priced at $35 USD per month, per forever. 🙁 Free Premium ILE RPG Editor for IBM i – ILEDITOR I’ve been waiting for a simple free-format RPG editor for the longest …

Read More

TURNOVER Client for Windows I really like the Softlanding (aka Unicom) TURNOVER for Windows, aka Turnover CLIENT aka Turnover Graphical Editor. It’s simple to use, not as clunky and old fashioned as the terminal based green screen menus and it’s just simple. Being simple myself, I like simple. 😉 Some people love the graphical editor. …

Read More

+Happy New Year 2018. One of my new years resolutions was to write cleaner code, and in the spirit of out with the old and in with the new… I already use the RPG COPYRIGHT statement and the CL COPYRIGHT STATEMENT to store the copyright message and (more importantly to me) the Version or Release number …

Read More

I wanted a handy little RPG code snippet to return the day name for a date. My requirement was to  feed in a date like “Nov 30 2017” and it to tell me that its ‘Thursday’. Google to the rescue, I found a nice little article by RAFAEL VICTORIA-PEREIRA (Thankyou Sir!) which has a code sample …

Read More

OK. I will admit that I’m a fan of IBM i ACS, it’s a long awaited breath of fresh air and a great replacement for the old AS400 Client Access connectivity suite. So when I foggily log on to my windows machine, gulping the mornings first scalding mouthful of todays (slightly dodgy tasting if truth be …

Read More

Search Scan Replace text in IFS files on IBM i using QSH This morning I wanted to find a quick and dirty way to “Scan Replace text in IFS” files without writing a program to do it…. SPOILER ALERT – it’s really really insanely simple using JAVA QSHELL and the SED command So, before I …

Read More

Let’s play with RDi and CL! I was happily editing some CLP code in RDi and very pleased with the Rational Developers automatic code reformatting: stretching out my Control Language code to fit the screen neatly. This is a nice enhancement to the code editing experience and blows the trusty old SEU workhorse out of …

Read More