RPGPGM.COM - The IBM i blog

In my last post I wrote about how to list a file's key fields using the file QADBKATR to retrieve the key fields' information fro...

On Tuesday, May 7 2024, IBM announced a new model IBM Power 10, S1012, which caught my eye. It is smaller than the other IBM Power rack mo...

I was asked how I could present the following information in an "easy to use" manner for all of the "files" in a libra...

Today, at a later time than previous announcements, a new set of Technology Refreshes were announced by IBM for the currently supported re...

Coming up with a meaningful title for this post proved harder than normal. I was asked a question about how to fetch data, using a SQL Cur...

Several years ago I wrote a post about the Db2 for i (SQL) Views about Views: SYSVIEWS :  Information about Views themselves SYSVIEWD...

When I wrote about the Db2 for i , or SQL, scalar function to create a Microsoft Excel spreadsheet in the IFS my example program ran inte...

What I call totally free RPG and what IBM calls modern RPG has been around for nine years. This type of RPG always needs the **FREE dir...

The idea for this post came from a question I was asked about using the Execute Immediate SQL statement . The questioner asked why he was ...

When I wrote about the Db2 for i , or SQL, scalar function to create a Microsoft Excel spreadsheet in the IFS my example program ran inte...

We have been able to send email from our IBM i partitions for several releases, using IBM commands and various third party tools. I use t...

This post is to take care of an oversight that was brought to my attention. I have written several posts about using the SQL three part na...