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

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

DSPF Indicator Command Keys in AS400 RPG (… and iSeries and IBM i obviously) Ever since my days at JBA, I’ve used the old-fashioned function key indicators to handle internal Function Keys selections, or Command Keys as they were known in the System/3x days. These PFKEY ranges from keys 1 through 24. Most programmers used

Read More

RE: Position of “AS/400 Lead” in NYC (Remote). I got this random email from a recruiter today: My initial feeling was this is a fake email trying to solicit people’s Curriculum Vitae for their database. But then I was tempted to email him back asking “Do you really mean AS400 Lead?” and perhaps helping them

Read More

How to find the last IPL date on AS400, iSeries or IBM i System IBM provides a neat little API program QWCCRTEC which prints a report showing how long the IBM i System spent in each of the IPL phases. IPL (Initial Program Load) is IBM speak for BOOT UP. An IPL on an IBM

Read More

What is the system part of IBM i Library List? SYS – System The System (SYS) portion is always at the top. This is typically the libraries containing operating system objects. You can add libraries to your JOB’s system portion using the CHGSYSLIBL command – NOTE THIS IS FOR YOUR JOB ONLY PRD – Product

Read More

IBMi Modernization The Challenge of AS400/ISERIES Application Modernization, Database SQL Conversion and Cloud Migration Regardless of where you are in the world and whenever you are reading this blog entry, 99.99% of AS400 and ISERIES applications are running on an IBM i Power System. The reason I saved a .01%, is because I know of

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