RPGPGM.COM - The IBM i blog

I have written about defining RPG variables defined as SQL types in past posts, which made me curious about all there are. Having searche...

There are times I stumble across things in the IBM manuals I felt I should have known. One of these is the ability to close all the files ...

It is that time of the year when the auditors start asking me for system information about the IBM i I am responsible for. The reports th...

This is going to be a quickie . I was asked: How can I get the 98th record from a file using SQL? Fortunately this very simple, but ...

Today is an exciting day as the latest Technical Refreshes for the currently supported releases of the IBM i are available to download as...

The germ for this post came from a question I found in an IBM i Facebook group. How could this person write a program where he would pass...

I was asked an intriguing question that I thought it would make a good post for this blog: Using SQL, how would I get a count of all re...

What appeared at first look to be a simple challenge given on Twitter: How would you get the system name of a partition via a SQL state...

This all started with what was going to be a very short post about using an Environment Variable to set the width of your debug screen. Bu...

I have written before about retrieving data from a XML file in the IFS . In that example I took that data from the file into a XML column ...

Video featuring Steve Will, chief architect of IBM i , and Alison Butterill, product offering manager for IBM i , showing ways IBM i client...

When I first started programming on the AS400 the biggest improvement I encountered, compared to the System/36 , was the external databas...