How can we Lockdown SQL Access for IBM i Users? Administrators often want to limit what SQL statements a user is allowed to run because how powerful SQL can be. What’s Different about SQL? SQL is a separate interface to the data and runtime SQL is part of the basic operating system. SQL uses the

Read More

It’s not someone that makes door handles is it? In software development a handler is a routine/function/method specializing in working with a certain type of data or focused on doing a special task. For example: Event handler – Receives and digests events and signals from the surrounding system (e.g. OS or GUI) or RPG HANDLER – Send/Receives data from

Read More

I was talking about RPG OA today. If you’re an IBM i techie, then you will know about OA already. You probably understand its power and potential in our IBM-i world. If you’re a bit more old school, you’ve been churning out column-based code for years, or you are living under a rock in a

Read More

I installed the first Technology Preview (aka Beta) for the new version of IBM i Access (aka Client Access) a few months ago. I really liked it, but was working on a clients project which had different standards for TN5250 and a few other things. So, to align with my team mates I worked with

Read More

What is RPG open Access ? Rational® Open Access: RPG Edition provides a way for RPG programmers to use the simple and well-understood RPG I/O model to access resources and devices that are not directly supported by RPG. Open Access opens up RPG’s file I/O capabilities, allowing anyone to write innovative I/O handlers to access

Read More