RPGPGM.COM - The IBM i blog

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

In the past I have only given examples of using LATERAL in SQL Select statements to get data from Table function . As such I have only me...

As part of the last Technology Refresh four SQL table functions were added that allowed me to extract certain journal entry types from th...

When the new version of ACS was released we were informed that a new version of "Navigator for i" would be forthcoming. Today...