Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
What’s new, Ubuntu 18.04 Linux? The biggest change is heralded as the switch from the traditional Ubuntu UNITY DESKTOP in favour of GNOME. I was a little nervous about what i was going to see when I upgraded my trusty old Thinkpad W700 from Ubuntu 17 to Ubuntu 18. But, surprise surprise, the desktop looks …
I’ve been playing with my home Wifi this week, trying to resurrect my old SCALEO Home Server which has been in deep coma since a brown out a few months ago. But I digress… So, I’ve installed a new router (Linksys WRT03200ACM) which gets mixed reviews but it looks so bloody Funky I just couldn’t …
IBM i, AS400, Programming, RPG
RPG INDICATORS are switches Just like car indicators (or ‘blinkers’ as my American cousins call them) they can be switched *ON or *OFF in a program to indicate the state of a certain piece of logic. In the IBM RPG language, it used to logically flick the switch of a numeric indicator 01-99 to “indicate” …
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 …
This week I ‘ave mostly been… trying to create a Gravity Form to allow users to pay for a Memberpress subscription using Stripe and then login and immediately get access to the subscribed content. Apart from that, I want to store my form data so I can review the new customer information from my SQL …
Leaving this Green and Pleasant land I lived the first forty years of my life in Southern England. A happy and traditional English childhood growing up in the Home Counties. Dad in the Army, Mum a housewife, grandparents for Sunday Lunch every weekend, two dogs and a thoroughly irritating little brother 😉 Growing up in …
AKA – writing a new DSPLY opcode that shows more than 52 characters Using the DSPLY opcode to quickly debug a program has long been a staple of us RPG keyboard whackers. The DSPLY operation lets us “display the data in a variable” onto the screen. Everyone uses this quick and dirty technique and everyone …
DevOps helps businesses respond to business, project and market changes quickly and fluidly. I’m not sure if fluidly is a word, but if its not, well, it should be. Devops focuses on many smaller high-quality software updates being rolled to users with a rapid schedule. Using continuous delivery and continuous testing to reduce risk, garner …
Override with Printer file (OVRPRTF) command is used to override certain parameters of the printer files used in the program or to replace the printer file.
...