HOME - IBM i, AS400 and iSeries RPG Software Developer Blog

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

Encrypt IBM i File (Table) Data with no RPGLE changes using SQL

I found this wonderful article over at Midrange Blog It does exactly what I am trying to do: Lets me[...]

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

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

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

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

So, I received a hacked email with an old password! Demanding payment with Bitcoin! #Blackmail

This morning I awoke to find an email from a digital blackmailer. This email shows one of my commonly used[...]

How to encrypt or hide CL/RPG Source Code in ILE Debug Views

Us programmers can be a secretive bunch. If you see a programmer running screaming from a meeting, clutching a program[...]

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

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

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

‘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[...]

Funky IBM i Email Validation Program using SQL Regex

Following on from my previous blog (basic email validation) I decided that it would much nicer to (a) have the[...]

Simple email validation SQL RPG ILE program

There are lots of code snippets, example programs and long waffling discussions in internet land filled with pointy headed AS400,[...]

Turnover Tip – Checkout to new library retaining source line changes dates

Wow - that's another long url title. I really wanted to call this "How To Check Out An Object From[...]

IBM i ACS 5250 EMULATOR FONT – and other ridiculous mumbo jumbo

What's in a font? Lots of things make our life easier as IBM i Programmers. Working with a clean, easy[...]

IBM i SQL statement to convert or compare hundred year date format

I had to pull records from two files with a matching date value in each file. To make things interesting,[...]

How to compare ‘100 Year Date’ to a Timestamp – aka – Weird AS400 iSeries Date formats

Back in the good old days of single megabyte disks the size of a shoebox, when hard drives were called[...]

Read all Nick's Waffle, Piffle and Bullshine

Digital Dad, Code Monkey, Irreverent Nerd and Semi-Professional Consumer of Cheese & Biscuits.