Many IBM shops have FTP locked down for supposed security reasons. But before I start ranting about sloppy security measures in IBMi shops all over the world; locking down things like FTP while leaving file uploads wide open, *public rights on file shares, inherited authority on commands line access, SQL scripts that are just waiting […]
More Waffle
I got the SNIP recently, but that’s whole different story to this very boring technical one… How to assign a keyboard shortcut to the Windows Snipping Tool I’ve been using the windows snipping tool a lot recently — to capture various 5250 screens and document them. I just remembered how to setup the tool against […]
More Waffle
I was emailed a little IBM i programming question this morning: An input parameter @Account is a 100 character string for one to x number of 8 digit accounts separated with a comma (,). Each account can be entered with commas between each account. Example: The string @Account could be “123,00574, 12,142 … “. Spaces […]
More WaffleIBM 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