RPGPGM.COM - From AS400 to IBM i

I am sure we are all familiar with using a copy compiler directive to copy source code from a "copy book" source member into ano...

When I run SQL queries, especially when retrieving system information, it is useful to include the IBM i partition name. I have been usi...

The next part of the process of moving the contents from IBM's now closed developerWorks to other new IBM sites occurred last week,...

Have you ever wanted to delete many, many spool files with just one command? You know the scenario someone decided to print every invoice ...

It was another one of those examples of a find when I was looking for something else. This is a SQL scalar function, SQL_CHECK_AUTHORITY ,...

I stumbled upon a YouTube series about PowerSystems myths given by Skip Garvin, IBM Lab Services Expert. The goal of this series is to d...

The last of the Christmas presents have been opened, and all of the decorations have been taken down and stored away. At the beginning o...

I have written about using SQL's RAND() to generate random numbers to be included in the returned results , but not to return a fixed...

In October IBM's developerWorks website started showing an announcement that it would be closing at the end of 2019. Then last mon...

At least once a day I use the Display Program command, DSPPGM , and the Display Service Program command, DSPSRVPGM , to look at the servic...