RPGPGM.COM - From AS400 to IBM i

One of the many additions to SQL in the latest round of Technology Refreshes, IBM i 7.3 TR 3 and 7.3 TR 9, is a Table function that displ...

SQL's DROP statement is pretty universal. It is used to delete just about anything that can be created in SQL: tables, indexes, views,...

I am often asked how is it possible to find the IBM i release and Technology Refresh level on a partition. In previous posts I have given...

All the celebrations to welcome in the New Year are drawing to a close, and we say farewell to an annus horribilis . I am sure I am not ...

Having brought up journal inheritance in my previous post I thought it would be wise to follow that up with this post. This post describes...

While this post is not going to be one of my longer ones, it is going to demonstrate another useful addition to Db2 for i within the late...

Last week I wrote about a new way in debug of changing the value returned from a procedure in a RPG program . Having had some time to look...

Many of us handle data coming from non IBM i sources, whether it be files sent from other types of systems or from web applications. Whil...

Sometimes it can be hard in testing to change values returned from procedures. I don't want to change the code in the procedure. But h...

One of biggest complaints I have always had about using data queues is that there is no easy way to see what is inside them, without remov...