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

WORK IN PROGRESS – Come back next week to see if this blog has been updated with some real time findings. It will be. I’m just busy in the real world and this is tricky stuff… I can tell you 😉 Using MariaDB (MySQL) with IBM i PHP Following Part 3 – where we verified

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

IBM i Housekeeping 101 – Deleting old Journal Receivers Following on from the blog I wrote about “What is an IBM i Journal?” We know that IBM i journals record what happens to files, and we know that this record is kept in these things called journal receivers: Now – since a journal can record

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

Another work week comes to an end. Another week when an executive asked “I’ve heard both names, do we have an iSeries or an AS400?” Another work week, where I had to gently explain, “We have an IBM POWER SYSTEM, running an operating system called IBM i.” Another work week, where I had to follow

Read More

SQLRPGLE Shorts – How to Call QCMDEXC with IBM i SQL Surely every RPG programmer is familiar with the QCMDEXC *API for exciting any IBM i Command from within any HLL (High Level Language) program. What is QCMDEXC? The Execute Command (QCMDEXC) API runs a single command. It is used to run a command from

Read More