IBM-i ACS is JAVA based, so it can be installed on Windows, MAC & Linux devices. The legacy IBM Client Access is no longer supported. IBM Client Access & ACS can both be installed on the same PC and live quite happily next to each other. So what are you waiting for? Standalone install By […]
More WaffleAS400 , IBM i , IFS , iSeries , SQL
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 and Test/QA boxes. Obviously we don’t want to implement any real […]
More WaffleAS400 , IBM i , iSeries , Website
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 […]
More WaffleAS400 , IBM i , iSeries , Programming , RPG , SQL
I’ve been involved in some heavy RPG modernization projects recently. Ranging from application replacements, to middleware webservice integrations to light code dusting…. I enjoy it all, just a little too much! Forget Alcoholics Anonymous, I should attend a software modernization addicts meetings where AA = AS400 Anonymous “Yes my name is Nick Litten and I […]
More WaffleAS400 , 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 […]
More Waffle
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 […]
More WaffleAS400 , 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 […]
More WaffleAS400 , 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 […]
More Waffle
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 […]
More WaffleAS400 , 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” […]
More Waffle