RPGPGM.COM - From AS400 to IBM i

I was asked how to make sure if I added 1 month to the last day of this month I would get the end of next month. If I take a date from a m...

This is the second part of a two part story. In the first part I described how I had downloaded a list of libraries from an IFS file to a...

This is the first of a two part story. I had found a number of libraries on an IBM i partition from the 2000s and 2010s for applications ...

I was asked how to make a list of empty IFS folders using SQL. My first thought was to go to the table function IFS_OBJECT_STATISTICS . B...

I need to keep reminding myself to use the SYSCOLUMNS2 SQL View rather that SYSCOLUMNS as IBM tell us that it gets the results faster th...

As part of the latest Technology Refreshes , IBM i 7.4 TR 5 and 7.3 TR11, we received a SQL View and Table function to use to get informa...

GENERATE_SQL_OBJECTS is a SQL procedure I have used which I have found very useful, but have not written about. It allows me to recreate ...

I have already written about how to delay a RPG program by less than a second by using the USLEEP procedure. Now I need to do the same in...

The idea for this post came from a question that was asked on Facebook. Someone wanted to create a subfile that would be projected onto a ...

I have wanted to have a way to get to the same information via SQL that I can by using the Display File Description command, DSPFD . This ...