IBM i , Programming , RPG
This is purely a little memory jogger for me. Nothing to read here move along move along….. I just upgraded an old program that had a piece of code doing this: C DS#POS Div 256 POSLIN C Mvr POSCOL This old RPG400 code is reading the cursor position from the display […]
More WaffleIBM i , Programming , RPG
Chum of mine was chatting to me about writing a trigger program. So I dug out this old trigger (that I copied from somewhere a couple of years back) and just ran through my RPGLE Modernizer routine: **FREE // // Skeleton trigger program using RPGLE V7.1+ //ctl-opt copyright(‘| @SKELTRIG V001 2019.04.19’) debug option(nodebugio:srcstmt) datfmt(iso-) timfmt(iso.) […]
More WaffleIBM i , IFS , Programming
An interesting question was lobbed at me this morning – “How can I change the data change timestamp in an ifs file?” One of the good folks over at Tire Rack (the software developers, not the blokes that change the tires) asked if I knew a way to update the timestamp for the data changed […]
More Waffle
Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. “What’s the best way to read all the spreadsheets in an IFS folder so we can process them?” bald bloke in the office Well, we have a nice simple technique to […]
More Waffle
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 Waffle