Author: tappehl

​[[{“value”:”The “R” in the title is no typo, no Q & A this time. The “R” does refer to the name Collection Services Collection in the screen shot, which is available in two flavours, but what is the difference? Well, that is a question that is easy to answer. There are two kinds of collection
The post Collection Services Q & R first appeared on PowerWire.”}]] Read More 

​[[{“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 

​[[{“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 

​[[{“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 

​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