RPGPGM.COM - From AS400 to IBM i

There is an old library, I am going to call it OLDLIB1 , that is still in everyone's library list. I needed to determine if there are ...

We all develop our own algorithms to validate email addresses. There must be an "@" sign in the string, there must be a period a...

I am sure when we sign on to a new partition and are prompted to change our user profile's password we spend several minutes trying to...

For the last few years I have been asked more often for a download, that can be loaded into Microsoft Excel, rather than paper report. Cus...

I was asked how it was possible to use a string within a spool file as the file name when it was copied to the IFS as a PDF. I have writte...

All I wanted was a quick way to check which Binding Directories contain a certain service program. Included in IBM i 7.5 and 7.4 TR 6 is...

I always place the code I use to create DDL tables, indexes, views, etc. in a source member. It has always frustrated me that the code cou...

When you are building SQL DDL Indexes to improve performance it is also imperative to find Indexes that are not being used. Having identif...

I am sure we have all used the Display Database Relations command, DSPDBR , to establish any file's or table's dependent objects. ...

Maintained Temporary Indexes, MTI , are SQL Indexes that have been created automatically by the Db2 optimizer, without any outside interve...