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

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

Change how Gutenberg looks when editing a page 1 – I like the WordPress Gutenberg Editor OK… OK…. I know there are two camps of people in the WordPress content editing world. There are those that like the new layout of the GUTENBERG editor with its block functions and, those that prefer the old tried

Read More