“Does IBM Access Client Solutions need Java to work?” One of my clients asked me this earlier today Nope. Not strictly speaking – since we can use The IBM Semeru Runtimes instead of Java. IBM i ACS does NOT need Java to work! Oracle owns Java. There are many alternatives to Java – some branched

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

Is the IBM i system worth it? This morning, I had a common question emailed in by a new subscriber: ​ I have been interested in IBM I for some time now (And Z/os). I even went so far as to buy a Power7+ 2u system for my home lab… only to find out the

Read More

WORK IN PROGRESS – Come back later to see if this blog has been updated with some real time findings. It will be. But maybe take a bit of time. I’m just busy in the real world doing real stuff and and this install is kind of tricky stuff… I can tell you 😉 Using

Read More

Ever wanted to find your IBM i OS Version using SQL? Following on from this blog about how to find the OS version from an RPG Program, a nice chap called Tomas Petris left a comment showing a slick way of pulling the IBM i Version with one SQL statement: The SQL statement is simple

Read More

How do I change an IBM i Webservice from SOAP 1.2 down to SOAP 1.1? And more importantly… Why would I want to do that? A client asked me “Can you change some of our IB i Webservices to use SOAP1.1?” Apparently, some MS Webservers are having problems with SOAP 1.2 when connecting to IBM

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

Verify MariaDB – MySQL on IBM i Following Part 2 – where we installed IBM i MariaDB (MySQL) – the next burning question is “OK, so it looks like it installed, so how do we check it and use it?” Me – with a coffee Now that we have MariaDB – MySQL is on your

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

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

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