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

* 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

Program QZCSOEOT in library *LIBL not found Using TURNOVER for IBM i? Have you got an error saying “Program QZCSOEOT in library *LIBL not found“? Have you searched your system and found no program called QZCSOEOT? Then it might be because your version of TURNOVER V101 has expired. Yes – it’s that simple. I saw this error on an

Read More

Using the same AS400 QRY in Dev, Test and Prod I had a good question from a subscriber today: We have a production environment and a test environment on our IBM i. We have processes in place to switch library lists depending on which environment we are in. We have issues where our test side

Read More

Join me on a mission to connect to a SQL Server database from IBM i This will be a growing blog… I’m going to use this to record a diary of sorts, chronicling my adventures in accessing and reading a Microsoft SQL Database direct from an IBM i application. Apparently, if the bods at Microsoft

Read More

Ever wanted to find your IBM i OS Version in RPG? Following on from this old blog about how to find the OS version from a CL Program (and when I say OLD I mean from back in 2009, when I was still young and crispy.. as opposed to how I am now; old, wrinkled

Read More

Ever wanted to use WordPress on IBM i? What is WordPress? WordPress is an open-source Content Management System written in PHP and paired with a MySQL or MariaDB database. Features include a comprehensive plugin architecture and a visual theme system. WordPress is powered by a webserver – what options do we have? HTTP Server for

Read More