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

Control Command Line Access Here is a brief guide on how to control command line access for IBM i users: IBM i User Limited Capability Feature The Limit Capabilities feature in IBM i allows you to control the ability of a user to run CL commands at a command line by specifying the LMTCPB (Limit

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

It’s time to install MariaDB on IBM i Following Part 1 – let’s dive into installing the actual thing and wade through any problems we see along the way. … Me – with a coffee MariaDB is a replacement for MySQL MariaDB is a fast, open-source, community developed branch of MySQL. Internal commands use the

Read More

Tinkering with one of my wordpress sites I noticed that Jetpack was unable to connect. The WordPress Jetpack Error says “Server unable to connect with my site http 404” which is nicely vague. Luckily, the excellent support guys over at ICDSOFT quickly gave me the solution: 1: Log into the control panel obviously your control

Read More

More questions about adopting authority on IBM i Systems and a technique to change user authority temporarily. So lets #discuss 😉 Adopt higher IBM i Authority to change System Configuration Question: I am needing to write a program, command, or whatever, that will enable my users to adopt a higher authority when they want to

Read More

An old AS400 Quiz So, last night I was nosing around in the dim dark corners of an old network share on my homeserver. I stumbled across an old TXT document from the late 90’s, I think. It was sitting in a text file called “AS400 Quiz Brainteasers” -it’s obviously old (look at the as400

Read More

System Request 3 Here’s a blast from the past: I was just testing an IBM i program that is importing data from a Windows Server, converting the data, juggling it, tweaking it and when its finished playing it finally shoves it into an IBM i Database. Fun Fun FUN! But if its running interactive and

Read More

Washington DC – President Trump announced his government is launching a special software advisory group – “Not long ago we all went through the Year 2000 crisis. If you were in the computer and software industry you recall the many headaches in converting and changing databases and software so the Year 2000 would be a

Read More

RPG PROGRAM USER(*OWNER) – Adopts the object owner level of Authority Most IBM i Programmers are aware of the USER(*OWNER) compile setting — anyone calling this program will adopt the authority level of the program. So if a program is compiled by user QSECOFR and USER(*OWNER) then anyone calling that program will automatically be elevated

Read More

So, just when I thought I had seen it all, I got this error message “Unable to move file into a new library” when I was just moving a file to a new library in my lovely IBM i System. Nothing weird about this file (or so I thought) and I was just going a

Read More