Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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” …
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 …
This morning I awoke to find an email from a digital blackmailer. This email shows one of my commonly used login email accounts plus one of my more commonly used password. Yikes! My password information has been leaked from somewhere! I’ve received several email just like this over recent weeks. Each time it shows my …
I recently updated the blog to use the very impressive THRIVE THEME called PRESSIVE. I love the SHOW IMAGE IN TITLE function on the blog pages. 90% of my blogs have a unique header image and I would like to go back and upate all (1k+) blogs to set this flag by default. Is there …
IBM i SQL – Using SUBST 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 …
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, …
AS400 DLS vs. IBM i IFS If you answered YES to any of these questions then I’m not surprised you’re confused! Sadly ,there are still a handful of people in the both the technical and business worlds that use the wrong names for (1) your IBM i Power System and (2) software running on your …
IBM i, Programming, RPG, SQL
Using SQLRPGLE to Validate email addresses in IBM i Following on from my previous blog (basic email validation) I decided that it would much nicer to (a) have the regex stored in a data area so that we can easily play with it to try different validation scenarios and (b) lets have a shot at …
Turnover Tip Tuesday Wow – that’s another long URL title. I really wanted to call this “How To Check Out An Object From One Library And Promote It To A Different Library but keep the program source code line change dates” but that just seemed too ridiculously long. Why are we talking about this? We all …
IBM i ACS 5250 EMULATOR FONT 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 appreciation for the new IBM i ACS (Access Client …
AS400 hundred year date format 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 …
