[[{“value”:”Another idea sprung to mind, I could use the OUTPUT_QUEUE_ENTRIES_BASIC SQL View to select the spool files I want to delete, and do the deleting in the same statement using the appropriate CL command in the QCMDEXC Scalar function .
The question was: Is there a way, using SQL, to delete all the spool files that have a particular form type?”}]] Read More
The Power of Profound AppEvo Coexistence Profound Logic
[[{“value”:”Discover how Profound AppEvo’s revolutionary coexistence technology enables organizations to Futurize IBM i legacy applications without disruption. Learn about granular futurization, automated integration, and innovative solutions like Genie UI Emulator and Proxy Program Objects that make seamless digital transformation possible while maintaining business continuity.
The post The Power of Profound AppEvo Coexistence appeared first on Profound Logic.”}]] Read More
Practical Middleware: Layering with JSON Joe Pluta
[[{“value”:”In the last article, rather than accessing the database directly using SQL statements, I wrote an RPG program, accessed via an SQL function, to retrieve customer data. This provides a layer of abstraction between the JSON application (which will eventually communicate with our users) and the database itself. In more technical terms, we separated the model from the view. However, we did that using the old, reliable transport mechanism of a data structure, which isn’t exactly common outside the IBM i world. Today we’ll investigate a modern alternative.
By Joe Pluta
Quick Recap
In the previous version, the RPG program returned a data structure, which the calling Node.js program split apart and used to populate an object. This was meant to emulate how an SQL call returns each row as an object. We replaced the SQL statement with a call to our RPG program (via an SQL function), and then the Node.js application parsed that data based on the layout of the data structure in the RPG program. We ended up with a couple of programs tied to each other by hardcoded positions and lengths:”}]] Read More
March 18th Member Meeting tlake
[[{“value”:”March’s topic: Better projects, objects and AI for IBM i is presented by Edmund Reinhardt. Discover the world of development on IBM i using intelligent projects in VS Code that know how to build themselves. This is modern application development brought to the IBM i.
RSVP and review additional information here: https://www.quser.org/content/quser-march-2025-ai-ibm-i”}]] Read More
Robot Monitor: How to Save and Share Robot Monitor Dashboards Fortra
Discover how to share Robot Monitor Dashboard setups with members of your team. Want to learn more about Robot Monitor? Click here: https://www.fortra.com/products/performance-and-application-monitoring-software-ibm-i Read More
