It’s time to move MOVE out of old RPG Programs One of the biggest mistakes I’ve made while trying to modernise old RPG code, is simply importing the old code and trying to take the whole thing as one lump upgrade to modern RPG ILE. Hindsight is 2020, and something I’ve learned from the many

Read More

RPG Subprocedure Tips and Techniques The use of subprocedures in your applications should be on everyone’s “to do” list this year. You don’t need to drop everything and rewrite your applications to take advantage of subprocedures and many other benefits that the Integrated Language Environment (ILE) offers.  However, when writing new applications or performing major

Read More

Comparing Object Authorities across different libraries is easier than you think! Using the magical powers of IBM i SQL we can easily create a spreadsheet containing all the objects in any given library and showing all their authority settings. You can run this SQL statement using green screen STRSQL or from your favorite desktop SQL

Read More

Restore and Rescope Logical Files When you restore a logical file, the system uses the description for the logical file to establish its relationship with the based-on files. For example, database views or indexes are logical files. You can restore a logical file to a library different than the library for the associated physical file.

Read More

Lots of IBM i Deleted Records? Want to find the 100 Files with the most deleted records in them? Ready to purge those Beauties? For years us AS/400, iSeries and IBM i Techies have been using the Display File Description Command to create output files containing record counts for files. The traditional process is something

Read More

Special Authorities – What are they on IBM i? If you come from the world of IBM I you will have heard of *ALLOBJ authority. This is the ultimate level of object access authority on an IBM I system. *ALLOBJ literally means you are authorized to read, change, or delete any/all objects on the system!

Read More

IBM i Authority is a wonderful beast with many layers of complexity. Like a big red onion, peeling back these layers is simple to do, but sometimes causes some tears, or occasionally full-on sobbing and weeping. The system can be anywhere from ultra secure to the other (naughty) end of the spectrum commonly known as

Read More

Want to find LARGE Objects on your IBM i System? First we need to collec the information about the fat objects on our machine — The Retrieve Disk Information (RTVDSKINF) command is used to collect disk space information. Then we can print this information and/or query it — Disk space information can then be printed

Read More

AKA Command Line Access from System Request 3 If you are an IBM I software developer or power user – then that headline will make sense. In fact, I can guarantee that’s the only reason you discovered and are reading this page. System Request 3 makes every RPG programmer twitch 3 fingers ready to reach those

Read More

Introducing IBM Semeru Java – regularly updated, community focussed, free and it does everything that Java does. The IBM Semeru Runtimes are free production-ready binaries built with the OpenJDK class libraries and the Eclipse OpenJ9 JVM. They deliver the power and performance of Java including all the latest up-to-date security and performance fixes. What’s not to love?

Read More

* Error Restoring Product Support Objects You are probably here because you are running a TURNOVER IBM i UPGRADE and have seen this error message in your job log. If you are not upgrading TURNOVER then leave now 😉 If you are – this is where I will document the various error conditions I’ve seen

Read More

What is TurnOver? Simply Put – TURNOVER is an IBM i Application that controls the flow of software development from writing code to testing to QA/UAT approval to installing on remote IBM i Systems. It has a long history dating back to the AS/400 and iSeries systems. TURNOVER is Change management for integrated IBM i,

Read More