AS400 , IBM i , iSeries , Programming
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 to love the new IBM i ACS (Access Client Solutions) with its multi-tabbed approach to […]
Continue reading
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 nicely convert dates stored in […]
Continue readingAS400 , IBM i , iSeries , Programming
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 off a byte here and a […]
Continue readingAS400 , 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 reading
So, 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 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 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 readingAS400 , IBM i , iSeries , Life , Programming , RPG
+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 […]
Continue readingAS400 , IBM i , iSeries , Programming
AKA Command Line Access from System Request 3 If you are an IBM I software developer or power user – then that headline will make sense. In fact, I can guarantee that’s the only reason you discovered and are reading this page. System Request 3 makes every RPG programmer twitch 3 fingers ready to reach those […]
Continue reading