My #%## SQL RPG Program Won't Compile

Compiling SQLRPGLE Programs that Contain Long SQL Lines

I had a need to create some SQL in the IBM ACS Run SQL Scripts and then wanted to transplant that code into an SQLRPGLE member for processing.   

When I compiled the SQLRPGLE program the SQL preprocessor was giving me odd pre-processor errors. 

As it turns out by default your SQL line width is most likely limited to 80-100 characters. 

Resolution

The easiest fix is to make sure your SQL statement lines are less than 80 characters.

-or-

The other option is to tell the compiler to allow longer lines when specifying *LVL1 or *LVL2 for the RPGPPOPT parameter. 

Here's an example using the PPMINOUTLN parameter in the CRTSQLRPGI command when creating an SQL RPG program: 

CRTSQLRPGI OBJ(&L/&N) SRCFILE(&L/&F) COMMIT(*NONE) RPGPPOPT(*LVL1)    DBGVIEW(*SOURCE) COMPILEOPT('PPMINOUTLN(500)')

Apparently you can skip the special compile option parm COMPILEOPT if you add a special environment variable into your current job like this:

ADDENVVAR ENVVAR(QIBM_RPG_PPSRCFILE_LENGTH) VALUE(500) 

You will still need to use the RPGPPOPT parameter set to *LVL1 or *LVL2.

What is my public IP address for IBM i

There are times you might want to check your public IP address from your IBM i system. Fortunately you can use the curl command and the QSHCURL command from a CL or RPG program to determine your current IP address if you're using the FREE QShell on i (QSHONI) software (https://www.github.com/richardschoen/qshoni) I created to integrate your PASE program calls to a traditional IBM i program. 

Making the CL API call to curl is as simple as this: 

QSHONI/QSHCURL CMDLINE('https://api.ipify.org') DSPSTDOUT(*YES)

And the results automatically show up in outfield QTEMP/STDOUTQSH for you to utilize from your CL or RPG programming. 

Example IP address response written from STDOUT to the first record of the outfile: 32.1.1.22

Check out QShell on i to be able to run curl commands and much more. 

If you find some interesting use cases create an issue on the GitHub site, post a comment or email me and I can publish as an example. 

What flavor of Linux do you like ?

 If you're interested in trying out the various flavors of Linux, check out this link. I learned about the site in the following link: https://www.zdnet.com/article/you-can-test-all-the-best-linux-distros-right-in-your-web-browser-with-this-site/

The actual site is called: https://distrosea.com/

Work with IBM i - A Modern Windows Alternative to PDM

As PDM and SEU continue to work towards being deprecated, the goal of the Work with IBM i project is to provide a FREE, Windows-based alternative for PDM developers who are beginning the journey of moving their development workflow off the green screen and onto the desktop.

While VS Code and RDi are both excellent development environments, having options matters—especially options that preserve editor freedom of choice and allow continued use of existing PDM user options.

Flexible Editor Support

With Work with IBM i, developers can use:

• The built-in internal editor
• VS Code
• Notepad
• Notepad++
• RDi (using a slightly modified workflow)

The software supports online and offline editing using virtually any Windows-based editor that accepts file names via the command line. Since Notepad++ is widely used in the IBM i community, this alone is a compelling reason for many developers to adopt Work with IBM i.

Another key advantage is that SSH is not required. Many shops prefer not to open SSH ports, and Work with IBM i works entirely through standard IBM i access ports.

Project Background

I originally started this project 4 years ago as a way to gain more practice with .NET Core WinForms, but it has proven to be far more useful than initially anticipated. The core application is completely FREE to use.

Purpose and Philosophy

The primary purpose of Work with IBM i is to provide a Windows-based replacement for PDM that looks and feels similar to PDM, allowing developers to work with IBM i source members without a 5250 green screen, while maintaining a familiar, PDM-like workflow.

The goal is simplicity:

Use the best editors available on the PC, keep existing processes where possible, and avoid forcing developers to learn an entirely new development model.

Git Integration with iForGit

Work with IBM i integrates with iForGit, the subscription-based Git source management solution for IBM i that I created.

Learn more:

• https://www.iforgit.com
• https://github.com/richardschoen/iforgit

The Work with IBM i client app provides direct access to iForGit CL commands, allowing you to commit changes to Git repositories directly from standard source physical files.

(An active iForGit annual subscription is required for versioning features.)

Editor Configuration Options

Although the application includes a built-in text editor, many developers prefer VS Code. Work with IBM i supports VS Code along with the Code for i syntax extensions.

You can configure separate editors and viewers if desired. Supported options include:

• Internal editor (default)
• Notepad
• Notepad++
• VS Code
• External workflows using RDi

Using RDi requires downloading source locally and editing outside the application. Detailed instructions are available here:

https://github.com/richardschoen/workwithibmipdm/blob/main/using_rdi_for_editing.md

PDM User Options Support

PDM user options are supported, provided they do not rely on a 5250 interface.

The default PDM options file is:

QGPL/QAUOOPT

This can be changed in the settings file, allowing you to reuse your existing PDM user option commands directly within Work with IBM i.

Offline Editing and Visual Feedback

The client tracks whether a source member has already been downloaded for offline editing and provides visual indicators in the UI. You can:

1. Download source to your PC
2. Edit it offline
3. Upload changes once reconnected

This editing workflow enables productive development even when disconnected from the system.

Future Enhancements

As a future enhancement, .NET developers will be able to create custom alternatives to PDM user options using a C# plugin model.

Connectivity

❗ IBM i access ports used for communication:

• 446–449
• 8470–8479

No SSH access is required.

Getting Started

Getting started is simple:

1. Download the application. Visit the GitHub site below to request access.
2. Unzip it 
3. Launch it
4. Enter your IBM i user profile, password, and host name or IP address

You’ll be connected and ready to start using PDM—on Windows.

Have fun, and please leave feedback or report issues on the GitHub project page.

https://github.com/richardschoen/workwithibmipdm

Moving IFS Files Between IBM i and Linux Systems Just Got Easier with QSHSCP

If you’re anything like me, you’re always looking for efficient ways to move files and objects between systems. Over the holidays, I needed a fast, reliable way to transfer files between two IBM i systems and a Linux system using SSH. Since scp is already part of the IBM i open-source SSH tooling, it felt like the perfect foundation for a simple utility command. That’s what led me to create the QSHSCP command and share it with others who utilize my QShell on i app. 

The QSHSCP command is essentially a thin CL wrapper around the PASE scp command. It allows you to securely send and receive files over SSH connections without having to drop into a shell session. While my usual go-to tool is SFTP, I found SCP to be surprisingly efficient once I started working with it.

With QSHSCP, I can easily send IFS files between IBM i systems, as well as to and from Windows, Linux, or AIX systems—such as a cloud-based backup server or an IBM Power Cloud environment.

One intentional design choice—whether you see it as a limitation or a strength—is that QSHSCP only supports SSH key-based authentication. By relying exclusively on public/private key pairs, there’s no need to exchange or store passwords between systems, which improves both security and automation.

Below is an example of using the QSHSCP command to send a file from a local IBM i system to a remote IBM i or Linux system for backup purposes or to deploy new objects:

QSHONI/QSHSCP CMDPFXPARM('-v')                                    
      KEYFILE('/home/user1/.ssh/id_rsa.ppk')     
      USER(user1)                                     
      HOST(myhost.com)                       
      PORT(22)                                       
      ACTION(*SEND)                                  
      REPLLOCAL(*NO)                                    
      LOCALFILE('/home/user1/mylib.savf')          
      REMOTEFILE('/home/user1/mylib.savf')         
      DEBUGCMD(*NO)                                    
      DSPSTDOUT(*NO)                                   
      PRTSTDOUT(*NO)        

QSHSCP also serves as a solid starting point for building additional SCP-based utility commands on IBM i. As part of my upcoming MobiConnect product, I’ll be adding extended object management capabilities—allowing you to directly save and restore IBM i libraries, objects, and IFS files over scp. In additional to object management utilities MobiConnect will make it easier to integrate IBM i with open-source applications and web services from traditional CL and RPG programs.

For more details on the FREE QSHSCP command, visit: the QSHSCP command URL

To learn more about MobiConnect and connecting all your systems and applications, visit: https://www.mobigogo.net
Email: info@mobigogo.net or richard@mobigogo.net

Interesting Git Error today: "The remote end hung up unexpectedly"

I received an interesting Git error today: "The remote end hung up unexpectedly".

Sounds like an unwelcome phone caller.

However the article link below points out simply that the git command needs a larger buffer allocated to it. 

I have not seen this error in several years of using git. 

At least there's a quick fix. Run the following git command to set your git post buffer size. 

git config http.postBuffer 524288000 

https://stackoverflow.com/questions/15240815/git-fatal-the-remote-end-hung-up-unexpectedly

My List of Favorite MacOS Apps

 What's your favorite MacOS app or tool ?

I wanted to start keeping track of the various apps I use or have tried so I decided what better place than a GitHub page.

Drop an issue or pull request on the GitHub site with your favorites or feel free to to comment here.

https://github.com/richardschoen/macapps

Dynamic SQL with Soft Coded Parameters from IBM i CL Programs

Dynamic SQL from IBM i CL commands has never been easier. RUNSQL and RUNSQLSTM have been available for years to run SQL statements or stored SQL scripts. However they have always lacked the ability to create queries that contain dynamic parameter values. Think about how powerful these two commands become with soft coded parameter markers.

Imagine running an embedded dynamic SQL statement from a CL program and also passing parameters to the query on-the-fly. Or think about being able to store an SQL query template in a source member or IFS file with parameter markers ready to be run dynamically.

The following SQL helper commands were recently added to my IBM i QShell on i utilities to make life easier when you need dynamic SQL in a CL program or process. QShell on i is available on the following GitHub site. https://github.com/richardschoen/qshoni 

Read on for an example of how to use the commands:

RUNSQLPRM — Run SQL Action via SQL Stmt with Parm Replacement

This CL command is a nice way to run dynamic SQL action (non-query) commands via RUNSQL. The command allows us to pass soft-coded parameters to SQL statements, effectively giving the RUNSQL command superpowers by allowing substitution parameters to be used much like parameter markers. This makes action queries much more dynamic when embedding SQL in a CL program.

Here’s an example of RUNSQLPRM inserting a record to QIWS/QCUSTCDT by passing a SQL statement template and parms for @@LIB, @@FILE, @@CUSNUM, @@LSTNAM and @@QT to pass single quotes to a query. All keyword instances get replaced with selected parameter values.

RUNSQLPRM SQL('INSERT INTO @@LIB.@@FILE (CUSNUM,LSTNAM) 

         VALUES(@@CUSNUM,@@QT@@LSTNAM@@QT)')                 

         PARMS(@@LIB @@FILE @@CUSNUM @@LSTNAM @@QT)         

         PARMVALS(QIWS QCUSTCDT 123456 Test '''')           

         NAMING(*SQL)                                       

         DSPOUTPUT(*YES)

RUNSQLSRC — Run SQL Action from SQL Src with Parm Replacement

This CL command uses the same process as RUNSQLPRM to run dynamic SQL action (non-query) commands, except that it uses the RUNSQLSTM command (instead of RUNSQL). In addition, the RUNSQLSRC SQL queries are sourced from a source member so template SQL action query scripts can be created with reusable soft-coded queries.

Here’s an example of RUNSQLSRC inserting a record to QIWS/QCUSTCDT using a SQL source member that contains template parms for @@LIB, @@FILE, @@CUSNUM and @@LSTNAM. You can use whatever values you want but I have found @@ to be an adequate parameter marker header. 

Sample query source member SQLTEST4 in file QSHONI/SOURCE with parameter markers. 

INSERT INTO @@LIB.@@FILE 

(CUSNUM,LSTNAM) VALUES(@@CUSNUM,'@@LSTNAM')

Sample call to the RUNSQLSRC command using source member SQLTEST4 with substitution variables and values.

RUNSQLSRC SRCFILE(QSHONI/SOURCE)                 

          SRCMBR(SQLTEST4)                       

          PARMS(@@LIB @@FILE @@CUSNUM @@LSTNAM)  

          PARMVALS(QIWS QCUSTCDT 123456 Test)    

          NAMING(*SQL)                           

          DSPOUTPUT(*YES)

Caution when naming your parameter marker values

When using parameter markers make sure each parameter name is fully unique. For example don't have parameters named @@NAME and @@NAME1. If @@NAME were to get processed first in line, it would also replace anything with @@NAME1 as well but leave the 1 at the end of the value. One way around this could be to use a trailing parameter marker as well.  Ex: @@NAME@@ and @@NAME1@@. Or something like: @NAME@ and @NAME1@. I just try to always keep my named parameter markers unique.  

Make sure to visit the QShell on i GitHub site to stay up to date on QSHONI enhancements. Also feel free to suggest new commands or enhancements in the Github site issue pages, and to contribute!

Modernizing IBM i Integration with Linux on Power

As businesses evolve, the ability to connect legacy systems like IBM i with modern applications, trading partners, and cloud services is no longer optional—it’s essential. For IBM i shops looking to bridge that gap without a complete overhaul, Linux on Power Systems offers a smart, scalable path forward to enhance IBM i integration and connectivity.

Why Connectivity is Key
IBM i has long been a rock-solid platform for enterprise workloads. But in a today's digital world, you need more than stability—you need flexibility. That includes real-time data exchange, modern APIs, scripting support, and access to the open-source ecosystem.

Enter: Linux on Power

Running Linux on IBM Power Systems—or even on x86 or ARM platforms—gives you immediate access to the latest tools and languages like:

• PowerShell
• .NET
• PHP
• Python
• Node.js
• Go
• Rust
• Java/Kotlin
• Bash
• And many more

With Linux on Power alongside IBM i, you can develop, automate, and integrate without disrupting your core systems.

What You Gain

• Bus level high-speed connectivity between IBM i and Power Linux partitions
• Enhanced connectivity to cloud and trading partners
• Modern development frameworks
• Open-source tooling at enterprise scale
• Cost-effective modernization
• A hybrid platform that plays to the strengths of IBM i and Linux

Ready to Connect IBM i to the Future?
Learn more and explore documentation at:
🔗 Linux on Power Overview – IBM

Feel free to reach out with questions.  

PASE (Portable Application Solutions Environment) and QShell on IBM i feels a lot like Linux

PASE (Portable Application Solutions Environment) and QShell on IBM i feels a lot like working in a Linux or UNIX environment, and there's a good reason for that.

Why PASE Feels Like Linux

PASE is essentially a runtime environment on IBM i that allows AIX (IBM’s UNIX) binaries to run. Since AIX is UNIX-compliant, and Linux shares much of the same philosophy and command-line behavior, working in PASE can indeed feel like working on Linux.

Here are some similarities and practical takeaways:

---

Similarities Between PASE and Linux

• Shell commands like ls, cd, pwd, grep, cat, grep, etc., are available in both environments.

• File system navigation behaves similarly (though the underlying file systems are quite different — IFS on IBM i vs ext4, xfs, etc. on Linux).

• Environment variables like $PATH, $HOME, and others are used in both.

• Scripting with shells like sh, ksh, or even bash (if installed) can be practiced in both systems.

• SSH access allows terminal-based work just like in a Linux shell.

• Tools like vi, awk, sed, ps, kill,nano , and cron are either identical or very close in functionality.

---

What’s Different

• QShell vs PASE:

  • QShell is a POSIX-like shell on IBM i, but it's not a full UNIX shell. It lacks some scripting features and behaves differently in areas like redirection and process handling.

  • PASE is closer to real UNIX/Linux, especially when running native AIX binaries.

• File paths:

  • IBM i uses the IFS (Integrated File System) which is different from the hierarchical Linux file system. /home/user might work, but behind the scenes, you're still dealing with IBM i objects and structure.

• Access to native IBM i resources:

  • Native IBM i commands (like WRKACTJOB, DSPLIB, etc.) aren't directly usable in PASE without special handling via the system command.

---

Why Working on One Helps with the Other

• Linux gives you muscle memory for shell navigation, scripting, and using standard UNIX tools.

• PASE gives you exposure to working in a hybrid environment, where UNIX concepts meet IBM i's robustness and control.

So yes — if you're an IBM i developer looking to sharpen your skills, getting comfortable with Linux can directly enhance your productivity in PASE and QShell, and vice-versa.

Simple IBM i Source Member Version Control

If you haven't implemented source version control on your IBM i system yet, but have a need to start easily capturing source member versions of your classic source from source physical files, we have you covered. 

In iForGit V1.25 a new feature has been added to handle simple source member version control for a team that isn't quite ready for using Git. And once ready for Git, the simple source management commands can still be used to manage moving source between production and development libraries if the source master versions will continue to live on IBM i in source physical files.

Developers can:

Check out a source member copy to their development or test libraries to work on the source. The source member can also be removed from the production library while being worked on if desired. Archive snapshots are always taken before and after source member checkouts so that no source ever gets lost. 

Check in a source member copy from their development or test libraries after completing work on the source. The checked in source member can be removed from the development library when checked in. Or a copy of the development source can be left in the development library once checked in for further work. Archive snapshots are always taken before and after source member check-ins so that no source ever gets lost. 

Capture an instant point-in-time archive snapshot of ANY source member at any time for backup purposes. This is helpful when working on a source member and you don't want to have multiple named copies of the source member lying around. Just take a snapshot and get to work on the source member changes. 

A database log is kept for all archive source versions so developers can easily identify an old source member by reviewing the log file. 

Getting started with source management has never been easier with the new Simple Source Management Commands built-in to the iForGit software. 

For more information to make your source management life easier, visit: https://www.iforgit.com and request more info. Or feel free to email: info@mobigogo.net

 

Who Stole my IBM i Disk Space ?

Solve Your IBM i Disk Use Issues with FREE Disk Utility
In some of my previous roles I often played an extra part as Disk Cop. This often meant scouring through thousands of libraries and directories to find large files and determining who owned them and why they were being kept online. If you understand the phenomena of the ever-growing disk usage you know why Cloud platforms have grown exponentially. It's because storage use never goes down. This post will introduce you to a FREE solution for handling your disk space woes. 

Most likely you might have these disk space questions:  

I need to check ALL the disk space on my IBM i?  

I can't seem to get a handle on our IFS files and I wonder what's taking up space?

The domain of checking free disk space used to belong to commercial utilities or the GO DISKTASKS menu, which was limited to locating only libraries. Let me introduce you to the Ncurses Disk Utility (ncdu). Ncdu is part of the open-source packages available for IBM i. To install ncdu from the PASE or SSH command line simply type: yum install ncdu  Or you can install ncdu from the Open-Source Package Management option in ACS.

After installation, simply change to the appropriate directory and type: ncdu or /QOpenSys/pkgs/bin/ncdu (if the open-source package binary directory is not in your file search path) from an SSH terminal command line. Ncdu must be run from an SSH terminal via putty or your favorite SSH terminal tool.

Listing Free Disk Space for a Single Library
After installation, go to an SSH terminal and log in to the command line and run the following command to check out the QGPL library and show the list of objects descending by size. Libraries exist as a directory inside of the /QSYS.LIB directory. 

ncdu /QSYS.LIB/QGPL.LIB

ncdu results for QGPL - largest objects in use at top in descending order 

After the object list is shown you can use the arrow keys to navigate the list of library objects IFS-style and determine which of them are the largest in-use objects. You can also type a question mark: ? to display options available. If you're brave enough you can use the d option to delete offending objects, but it might be safer to use this tool to identify large objects and delete them another way. It's up to you how you use the app. You have been warned to be careful when deleting objects!

Listing Free Disk Space for the entire IFS Root File System

You can also crawl the entire root / file system on your IBM i partitions using the following command:

ncdu /

It may take a few minutes to get an object list, but you now have a full picture of ALL the directories and libraries (everything under /QSYS.LIB) on your system. 

ncdu root / list results - largest objects in use at top in descending order

Once again you can navigate through the directories to locate offending objects and decide what to do with them. 

That's it. Start policing your IBM i disk space. 

ncdu is a great forensic analysis tool for determine large objects in use. Let me know if you find value in this tool. I surely have. 

This link on learning ncdu might also be helpful: 

ncdu Command Guide | Managing Linux Disk Usage (ioflood.com)

This link points to some ncdu export processing examples

wodny/ncdu-export: Standalone ncdu export feature (github.com)

If your team needs mentoring or learning how to use ncdu or automatically monitoring disk utilization, or if your team needs help with process modernization discovery, training, mentoring and integration services, reach out and let's talk about your business automation pain points. Your team will be on track to streamlining and modernizing your
IBM i processes in no time. 

Web Site: https://www.mobigogo.net

Email: info@mobigogo.net

ActiveMQ Can Integrate IBM i to Anything

In today's world there are a few ways to do platform agnostic messaging with IBM i. This post introduces you to ActiveMQ.

If your business has the need to send and receive messages and data across platforms in a transactional fashion, the classic way to do that internally on IBM i might be to use data queues. Data queues have been around since the early days of the AS/400. The AS/400 was introduced back in 1988. However data queues are generally used to communicate intra-system between RPG, CL and COBOL apps built within the IBM i operating system. In today's world of multi-platform communications with API calls and REST services across multiple servers and services, ActiveMQ and Kafka can be better vehicles for exchanging transaction data and messages than using data queues. The topic of this post will focus on using ActiveMQ to implement platform agnostic messaging from your IBM i. But the same concepts can be applied using Kafka and even RabbitMQ.

First some background on ActiveMQ from the ActiveMQ web site: Apache ActiveMQ® is the most popular open source, multi-protocol, Java-based message broker. It supports industry standard protocols so users get the benefits of client choices across a broad range of languages and platforms. Connect from clients written in JavaScript, C, C++, Python, .Net, and more. Integrate your multi-platform applications using the ubiquitous AMQP protocol. Exchange messages between your web applications using STOMP over websockets. Manage your IoT devices using MQTT. Support your existing JMS infrastructure and beyond. ActiveMQ offers the power and flexibility to support any messaging use-case. 

Let's talk about a few potential use cases for ActiveMQ messaging on your IBM i and other systems. These use case examples are meant to get you thinking about the potential uses for messaging with your apps. 

Shipment lookups - Let's say you have the need to do shipment lookups from an IBM i green screen or web application and it's not so easy to integrate to your shippers from RPG. You can set up a PHP, Node, Python, Java or other server that can easy make the calls to the external shipper. Then you set up a queue via ActiveMQ to receive the shipment lookup request data from your classic IBM i code. Requests are usually sent from direct RPG, COBOL or CL calls by composing a delimited request string of data, a JSON or XML packet. Response data can then be returned directly to your IBM i app from the message queue after a shipment lookup has been performed.

Realtime credit card processing - A credit card request can be composed from RPG and sent to your credit card processing program via JSON, a REST call and an ActiveMQ message. The credit card request gets processed and then the response token or other information can be returned back to the RPG program or directly to a DB2 database table once the transaction is complete. 

Incoming orders or mobile work - Let's say your company has implemented a mobile app to handle capturing new orders on an iOS or Android device. As orders are completed the data can be dropped into a message queue for ActiveMQ to pick it up and send the data to an RPG, COBOL or other process which ultimately updates the system of record database without needing to re-key order data. Orders and service requests could also be staged to a mobile device over message queues as well. 

Sending order or shipment data to e-commerce site - As orders and shipments get fulfilled from an IBM i ERP system, transactions can be queued up for a remote Linux or Cloud based e-commerce app to pick up. On the e-commerce site an agent can be set to receive the order, shipment or inventory updates and auto-update the SQL Server, Oracle, PostgreSQL or MariaDB database in real-time fashion.

Placing EDI supplier orders - Imagine your team currently enters material and parts orders into your IBM i ERP system and then the same orders end up being re-keyed by hand to your supplier's portal, even though they offer a web API.  What if new and updated orders could be entered into your IBM i system once and then updated in real-time to your supplier portal using their integration API. Many hours of manual effort can be saved by entering and checking supplier order status via a web API.

All of the above integration scenarios are available to your RPG, COBOL and CL applications without forcing your classic IBM i RPG development team to learn new methods of coding to implement APIs and integrations between your various application platforms and apps. 

For a little more in-depth reading I listed a couple of articles below. Read these if you want to learn more about ActiveMQ and give it a try with your IBM i. 

Using ActiveMQ message queues on the IBM I

ActiveMQ from PowerWire - Andy Youens

Apache ActiveMQ Site

If your team needs mentoring or learning how to use ActiveMQ, or if your team needs help with process modernization discovery, training, mentoring and integration services, reach out and let's talk about your business automation pain points. Your team will be on track to streamlining and modernizing your IBM i processes in no time. 

Web Site: https://www.mobigogo.net

Email: info@mobigogo.net