RPGPGM.COM - From AS400 to IBM i

On Thursday 23 October, 16:00 – 17:45 ( CET ), I am doing an online presentation to COMMON Austria , for their 16th "Know Your IBM i ...

In my previous post I described how I could add several constraints to DDL Tables. Here I am going to describe how I can do the same wi...

This is another one of those posts I did not realize I had not written about, database constraints. Constraints allow me to move the con...

At this month's TUG event my friend, Sue Romano, Senior Software Engineer at IBM, showed where we could go to download the latest ver...

What I have been predicting for a while happened on Tuesday September 16, 2025. IBM announced that the end of standard support for IBM i ...

The idea for this post came from a question I was asked. There were a number of program dump spool files , QPGMDMP , and the manager wante...

Today, September 15, Fortra's thirteenth annual "IBM i Marketplace Survey" starts. IMHO it is important for all of us, no...

I had a scenario where I needed to determine the remainder value following a division operation for all the rows in a SQL Table. Rather th...

Last week I was fortunate to be in Oslo, Norway, for COMMON Norge's "Professional day". I took this opportunity to hand ou...

In June I wrote about how to use SQL to check if a file existed in the IFS . I received a communication from Rich Diedrich offering an alt...

This almost slipped past me, the information in the IBM i 7.6 documentation that says that the Convert Date command, CVTDAT can use the ...

SYSDISKSTAT returns the information about disk and solid-state drives, SSD . It comes in two forms: SYSDISKSTAT View SYSDISKSTAT Ta...