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. * Error restoring product support objects. See job log for details. On our production machine we have strict password rules – and the automated install process …

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

RPG Rules – aka – When Rulers helped you program A few years ago, moving house for the umpteenth time, I found my old RPG Ruler from way back in the day. I think this is from the late 1980’s when I was learning to program RPG2 and RPG3 on the first IBM Machine I …

Read More

Email an IBM i File as a CSV Sample IBM-i Control Language Program to take a physical file (aka SQL Table) convert it to a CSV Spreadsheet and email to someone… somewhere.. First let’s create a nice little CMD wrapper to give us a smarter way of calling our CL code: and the executing CL …

Read More