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

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

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

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

How to Download IBM i SQL Results As CSV I had to run a rather interesting SQL statement to download journal information: What does this do? Essentially, this SQL snippet retrieves journal entry information for the given journal and the file that is journaled. Running this in the IBM i ACS SQL script explorer gives

Read More

How to get a JBA Supplier History by Country I was asked to build a spreadsheet showing “All purchase totals for all suppliers by year and include the supplier country code” A simple request – so I thought I would blog the process for those new programers out there or for anyone wanting to understand

Read More

Count with SQLRPGLE Variable File Name Been having fun with SQL and RPG ILE this afternoon… the question was “How do I find out if and how many policies exist in one of the reservation files for a given customer code?” Obviously, we could write a little piece of RPGLE doing a READ LOOP and

Read More

How to Substring a Packed numeric in a Logical File So – you have a Physical file and you want to create a logical with substrings of file data or maybe concatenation of the same data. “That’s easy” I can hear you think… but… but… what if you need to do this with a substring

Read More

How to delete first few rows from a file with IBM i SQL This morning I was working with a flatfile import from IFS into a DB2 database file. This should have been straight forward but the flat file contained several rows of crappy data at the start of the file. *ugh* Since I am

Read More

Let’s look at a quick little example RPG email validation program – SQLRPGLE ILE There are lots of code snippets, example programs, and long waffling discussions in internet land filled with pointy-headed AS400, Series, and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know

Read More