Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
AS400, IBM i, iSeries, Programming, RPG
I was discussing the benefits of RDi with a colleague this morning (I’m a bit of a Rational Developer fanboy) because he is trying to justify the huge annual cost of the tool with The Management: nearly $1000 per year per person! A price tag that is #bloodypreposterous. But, I will rant about that in …
IBM i Data Obfuscation – Making Data Foggy Murky and Squinty A little while ago, I wrote a data obfuscation tool – which I decided to call Data Fogging. This is specifically to solve the data privacy problems that we face when we want to suck down real data from production environments to our development …
So, I just did an upgrade of the BCD Software GUI Client (now owned by Fresche Legacy by the way) for a client. This upgraded their older version of Presto to PRESTO 8.1 Server. This also comes with a new Presto Client and Screen Designer adding some nice new tweaks. Compulsive Library Naming Tendencies The …
Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. I was surprised to see there were hundreds of files in this folder and he wanted to list them, and assign different files to different people. “What’s the best way to …
AS400 DLS vs. IBM i IFS If you answered YES to any of these questions then I’m not surprised you’re confused! Sadly ,there are still a handful of people in the both the technical and business worlds that use the wrong names for (1) your IBM i Power System and (2) software running on your …
IBM i ACS 5250 EMULATOR FONT What’s in a font? Lots of things make our life easier as IBM i Programmers. Working with a clean, easy to read 5250 terminal mode is one of the them. I’m a big fan of Mochasoft terminal emulator, but growing appreciation for the new IBM i ACS (Access Client …
AS400 hundred year date format I had to pull records from two files with a matching date value in each file. To make things interesting, the date on one file was stored in timestamp format and the date field in the other file was stored in hundred year date format. SQL (and QUERY400) can very …
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 …
IBM i, AS400, iSeries, Programming, SQL
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 …
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 …
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 …
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 …
