Category Archives for "IBM i"

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
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
Aug 29

IBM i User Profile – Special Authorities

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
Aug 09

‘device file does not contain an entry for screen size’

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 Waffle
1 2 3 43