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 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 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
Upgraded our IBM i systems to IBM i V7.3 yesterday and so far everything is running nicely except for this one weird little glitch: some of the existing DDS WINDOW SCREENS are bombing with CPF4169 The device file does not contain an entry for screen size when they seem to have been quietly working for years, […]
More WaffleIBM i , Programming , RPG , SQL
There are lots of code snippets, example programs and long waffling discussions in internet land filled with pointy headed AS400, iSeries and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know because I’ve read nearly all of them, as well as tried all the […]
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