Mar 20

What is AS400 modernization?

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
Mar 04

How to read a Data Area (*DTAARA) using IBM i SQL

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
Feb 19

An Englishman in America

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
Jan 08

How to update RDi – Rational Developer for IBM ‘i’ Programmers

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
Dec 05

Cleaning messy IBM i Integrated File System (IFS) file names

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 Waffle
Nov 05

Thrive Pressive Theme – SQL TITLE SECTION

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 […]

More Waffle
Oct 31

IBM i SQL – Using SUBST to insert data into a string

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
1 2 3 59