AS400 , IBM i , iSeries , Programming , 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 older QUERY400 reports to modern SQL […]
Continue readingSo, we have a customer masterfile 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 filthy dirty file filled with grubby email […]
Continue readingI’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 […]
Continue readingAS400 , IBM i , 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” […]
Continue readingIBM i , Programming , Webservice
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 […]
Continue readingIBM i , Programming , RPG
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 […]
Continue readingIBM i , Programming , Software Change Management
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 […]
Continue readingIBM i , Webservice , Website
Or as the grey haired folks would say “How to configure the ISERIES FTP server to use SSL” or as the geriatric brigade would say “making the AS400 talk using that newfangled secure FTP nonsense“. But of course, we know those old computers dont exist anymore and we know that some old people are crazy… […]
Continue readingAS400 , IBM i , iSeries , Programming , RPG
I found this article ages ago and book marked it. I just re-read it and found it just as pertinent today as when it was written 15+ years ago! Tips to reduce static storage The variables in an ILE RPG module or program can be divided into three storage (memory) classes: static, automatic, and heap […]
Continue readingAS400 , IBM i , iSeries , Programming , RPG
I’ve been waiting for a simple free-format RPG editor for the longest time. Opensource ILEditor delivers. It’s free, open source, actively maintained and growing in support. It’s quick and simple to use, and I can already see that as it’s popularity grows new functions will be easy to add. #nice The Author is Liam Allen […]
Continue reading