IBM i Utilities Based on QShell on i (QSHONI) Library

This repository is meant for miscellaneous add-on utilitites that utilize the QShell on i library (QSHONI).

All utilities listed here are FREE to use. Sample commands and code contributions are also appreciated.

MobiConnect - Modernizing and Connecting IBM i to the World

I am releasing a commercially supported product called MobiConnect. MobiConnect provides functionality for creating applications, integrations, REST services and connection points for Native IBM i, Windows, Linux and MacOS apps to other platforms and services. It contains a lot of functionality that is better suited for commercial support. And it uses some of the QSHONI functionality as well.

If you are creating IBM i applications and services that need to integrate with other platforms or AI services, reach out and and we can talk about your requirements. MobiConnect may just be the right ticket for interconnecting your IBM i RPG, COBOL and CL apps to the world of web apps, REST services and mobile with minimal effort.

Visit the MobiGoGo web site or shoot me an email and talk to me about your IBM i connectivity and integration needs or need assistance with running QShell and PASE apps on IBM i.
MobiGoGo: https://www.mobigogo.net
Email: richard@mobigogo.net

Recommended location for building any of the commands from this site:

Source Library: QSHONIUTIL
Source File: SOURCE

However you can really put these anywhere.

Currently utilities placed here are source only.

❗These commands just need the QSHONI library from the link below before they will run.

Creating QSHONIUTIL Library and Source File

Create the QSHONIUTIL library

CRTLIB LIB(QSHONIUTL) TEXT('QShell on i Utilities') 

Create QSHONIUTIL source file

CRTSRCPF FILE(QSHONI/SOURCE) RCDLEN(120) TEXT('QSHONI Utility Source')

See the following link to get the QShell on i library

The QShell on IBM i library contains useful CL wrapper commands to allow QShell and PASE apps to be called and consumed from regular IBM i jobs via CL, RPG or COBOL programs.

https://github.com/richardschoen/QshOni

Utility List

You can enter or upload these source members using VS Code, RDI or an other IBM i source code utility application.
GENXLSACS - Generate Excel File Using IBM ACS Jar File
Not much to say about this one other than it wraps around the ACS functionality. It was based on a utility created by Scott Schollenberger he posted over on the IBM TechXchange forum. Thanks for the inspiration Scott.
Compile the CL command associated CL program and make sure QSHONI is available on your system. https://github.com/richardschoen/QshOniUtil/tree/main/GenerateExcelWithAcs