Today I be mainly playing with UIM MENU’s that bloke from the fast show … and I found that Rational Developer for IBM i doesn’t come out of the box ready to edit UIM MENU source types! So, if like me, you are playing with UIM Menu’s make sure you add the source type menu […]
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 Waffle
I found this wonderful article over at Midrange Blog It does exactly what I am trying to do: Lets me encrypt a certain field (column) in a table so that its encrypted as its added and updated. It also lets me automatically decrypt it when I read the record back (the only caveat is that […]
More Waffle
Our first problem is, SQL doesn’t know what a *DTAARA is. SQL reads data from Tables but our gloriously quirky IBM i Box has other places to secretly store data. Data Areas are just one of these tricky little blocks of data that other machines don’t know about – think of them as a single […]
More Waffle
To quote Sting ” I’m an alien, I’m a legal alien I’m an Englishman in New York” But, over the last ten years I’ve enjoyed being an Englishman in Roanoke VA, Augusta GA, Charleston SC, San Clemente CA and now Las Vegas NV. Diverse locations with diverse cross sections of the People that make up […]
More Waffle
Last night was I was chatting to an old programming chum in Chicago. As you may be aware, for most people in the AS400/iSeries/IBM-i arena the term “old programming chum” automatically implies a gray haired old fart wearing frayed cords, cheap (but comfortable!) shoes and excessively dour facial features with a slightly “smarter than thou” […]
More WaffleIBM i , IFS , Programming
This morning I had an email from a blog subscriber ( Hi Rick! ) asking for a code tips on how to cleanup IFS file names to remove erroneous characters and/or malformed directory name slashes. Rather than reply with a plethora of programming options — here is an old, but functional, RPG code snippet that […]
More WaffleIBM i , Programming , SQL
A while ago I had a problem where I wanted to change the first two characters in a table and I used the very simple concat and subst operations to do it with SQL. Today, we had a slightly more complex requirement of updating text in the middle of a field using SQL, or in […]
More Waffle
IBM i Authority is a wonderful beast with many layers of complexity. Like a big red onion, peeling back these layers is simple to do, but sometimes causes some tears, or occasionally full on sobbing and weeping. On the positive side, setting these layers of authority is pretty straightforward as long you stay focused and […]
More Waffle