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

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 WORK IN PROGRESS Check back tomorrow.

...
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

Going for the Guinness Book of Records for vague blog titles I decided to waffle about inner joins and outer joins in the world of bellybuttons *cough* Structured Query Language. Since plagiarism is the best form of flattery, Chirag Sharma (over at Guru99) wrote a very nice article about the finer points of SQL INNER

Read More

Only Numpty Programmers hardcode library names #internetfact One of the mumbling, drooling, gray haired programmers on my team asked me to peer review his code this morning. This was for a simple SQL table to be created and promoted through multiple environments using TURNOVER. The code looked something like this: CREATE TABLE MYLIB/TESTSQL ( TSTFLD

Read More