Author Archive for: Richard

Entries by Richard Schoen

New QSHONI Commands for SQL and IFS on IBM i

/in /by

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

New QSHONI Commands: Integrate Python, PHP, Java with CL & RPG

/in /by

A 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 traditional IBM i applications. I keep thinking I will run out of interesting things to add to the library, but the ideas keep on flowing.

Call/Parm Your Open Source Apps from RPG and CL with QSHCALL

/in , , , /by

A few years back I created the QShell on IBM i (QshOni) project to allow QShell/PASE (open source) apps to be more easily integrated and used with traditional IBM i job streams written in RPG and CL. Since then, many developers have adopted QshOni to utilize their open source apps in conjunction with their classic traditional apps. Recently I added several new commands to QshOni to make living the PASE life even easier for RPG developers. Today’s focus will be on the QSHCALL command.

curl Your RPG Apps with QSHCURL

/in , , /by

In this post we’ll take a closer look at how IBM i developers can use the QSHCURL command to easily reach out from CL or RPG and talk to internet-based services and APIs, then consume the resulting data, without a lot of extra effort. First we’ll provide a short curl intro, and then we’ll look at an example of how to use the PASE-based curl command with an RPG program.

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

/in , , , /by

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

Integrate Python into CL & RPG on IBM i – 2021 Update

/in , , /by

Python on IBM i has proven itself as a tool for building utilities to create/read Excel files, transfer data, automate processes, call REST APIs such as Salesforce and ServiceNow, monitor applications, and more. What was missing was an easy way to use the power of Python from CL and RPG. In 2019 we introduced you to the PYRUN command for running Python scripts from CL and RPG programs. In this post we introduce you to QSHPYRUN, the next generation of PYRUN and part of Richard Schoen’s open source QShell on i Library – QshOni. QSHONI makes it easy for traditional…

Welcome Back, MariaDB!

/in , , /by

Getting Started with MariaDB on IBM i MySQL 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.