New QSHONI Commands for SQL and IFS on IBM i

QSHONI integration for IBM i RPG, CL and open sourceQShell on i utility (QSHONI) makes it easy for traditional CL, RPG, and COBOL programs to call Python utilities and other QShell/PASE utility programs (PHP, Node, Java, etc.) and directly use their output. Last month we updated you on three new QSHONI features: QSHPHPRUN, QSHCALL and QSHPYCALL.

This month we will cover several other new and updated QSHONI features added in the past 12 months. Use the following quick links to read about a specific command.

Read more

PHP: The “RPG” of Open Source for IBM i

Reliable. Versatile. Fast. The terms we use to describe modern RPG applications apply to PHP as well. That’s why PHP remains a top choice to supplement RPG for IBM i projects involving the web, APIs, and high-volume transactions.

One sterling example is Curbstone’s PCI-validated payment solution, which uses PHP-based portals to process over 8 billion dollars in credit card payments annually with 99.99% uptime availability.

Read more

PHP 8.3 for IBM i Released in Seiden PHP

PHP on IBM iLast week the IBM i community got PHP 8.3, the newest version, via Seiden PHP+.

While PHP 8.3 has valuable updates, PHP 8.0 and lower are no longer receiving even security fixes, increasing your risk of issues with security and certainly with your next security audit. Contact Alan for a free upgrade assessment.

PHP 8.3’s new features include json_validate. You’ll find the full list of changes and supporting details at PHP.Watch.

Read more

Integrate Python, Node, PHP, etc. with CL & RPG on IBM i – 2023 Update

QSHONIA few years ago I introduced you to my QShell on i utility – QSHONI. QSHONI makes it easy for traditional CL, RPG, and COBOL programs to call Python utilities and other QShell/PASE utility programs (PHP, Node, Java, etc.) and directly use their output. QSHONI opened up a whole new world of integrations to open source apps from RPG, CL, and COBOL.

In this post I will update you on new features that have been added to the QSHONI utilities over the past 12 months.

Read more

Install and Use Node.js iToolkit for IBM i

node.js ibm iNode.js has joined other popular IBM i open-source technologies, such as PHP and Python, for web application and API development. A server-side runtime for JavaScript, Node.js can run both on IBM i and on other platforms such as Linux.

The Node.js iToolkit lets you leverage your company’s investment in RPG and COBOL business logic while developing front ends and APIs with Node.js. As with Node.js itself, iToolkit can run on your IBM i or can connect to IBM i from your PC or an external web server.

This post explains how to install Node.js and its iToolkit on your IBM i, then use iToolkit to call an RPG service program.

Read more

Case-Insensitive Queries using ODBC on IBM i

ODBC with Db2 for IBM iWhen querying for character data using SQL, case matters. “A” is not equal to “a”. Even so, you might want to find all matches, whether uppercase, lowercase, or mixed case.

Read more

VS Code for IBM i — Tips and Extras

Visual Studio Code 1.35 iconVisual Studio Code is a widely used IDE in the non-IBM i world. Recently we released Code for IBM i, a freely available extension for VS Code that supports RPGLE and COBOL development for IBM i. You can read about the basics of Code for IBM i and about code coverage functionality in my previous posts.

Today I’m going to cover three additional tips for using Code for IBM i. Of course, for any of this to work, you need to install Code for IBM i.

Read more

Visual Studio Code, RPG and Code Coverage

2023 Update

The Code Coverage extension for VS Code for i remains in development
and is unavailable at this time.


This is the second post in my series on RPG and COBOL development using Visual Studio Code and Code for IBM i. Today’s topic is Code Coverage.

Read more

Issues with Port 10080

You might have heard that the major browser vendors were planning to block port 10080 – the port used by Zend Server through ZS 8  (PHP 5.6). Firefox made the first move, then Chrome followed. We have been receiving support requests on this issue since April 2021. Why did the browser vendors block port 10080, and what can you do to get your site working again?

Read more

Welcome Back, MariaDB!

Getting Started with MariaDB on IBM i

MariaDBMySQL and MariaDB have long been databases used in the Linux world for popular web apps in PHP and other languages. The collective development components—Linux, Apache, MySQL and PHP—are often called the LAMP stack. When PHP was released on IBM i in 2006, the combination of IBM i, Apache, MySQL and PHP became known as the iAMP stack.

Read more