RPGPGM.COM - The IBM i blog

In the past I have written about generating pseudo-random numbers using APIs, CEERAN0 and C's rand . But I always return to using SQL...

The seed for this post came from a conversation I had with one of my work colleagues. He complained that even though he could give the col...

While poking around in IBM's developerWorks wiki I noticed that pages for the next Technical Refreshes for IBM i 7.3 and 7.2 have alrea...

In a previous post I wrote about how to perform an update of the current row/record when using a SQL cursor in a RPG program . I have been...

In an earlier post I described how to retrieve information from a XML file . This left me thinking how do I create a XML file just using n...

I was asked how to update the current row if I am "reading" a file/table using a SQL cursor. At first this question took me abac...

After my post about how to create your own commands I received messages from readers giving me examples of how they have created their ow...

I have previously written about using the error subfile to display error messages , rather than the message subfile. Personally I like usi...

Until the last round of Technical Refreshes, IBM i 7.2 TR 7 and 7.3 TR 3, I could not find a way to retrieve the name of the procedure th...

I have written previously about how to handle nulls values in RPG and in SQL , but until this week I had never had a problem with nul...

I had received notification from a supplier that they were changing the order file they send my employer. Previously they sent a Microsoft...

One of the messages that annoys me the most is "Attempt to divide by zero". I am sure every programmer, no matter, what language...