IBM i Services for RPGers --AND-- Build a Phenomenal Web App on IBM i in Under 10 Minutes!
Channel: CNX Corporation
Date: 21/03/2023

Summit Lunch & Learn: IBM i Services for RPGers --AND-- Build a Phenomenal Web App on IBM i in Under 10 Minutes - No Coding Required!

IBM i Services for RPGers
with Susan Gantner

IBM i Services were initially focused on system administration. Recently many have been added that RPGers may find far more interesting.

Provided by a set of SQL views, functions and procedures, these services allow access to things that previously required system APIs or CL commands. They are easier, more powerful ways to retrieve information about application-related objects with the power of SQL (think SELECT ... WHERE ... GROUP BY, etc.) 

A few examples:

- Obtain lists of modules in ILE programs or SRVPGMs
- Read and write to IFS files
- Interact with Data Areas or Data Queues
- Grab contents of spooled files and/or delete old spooled files

--------------- AND ---------------

Build a Phenomenal Web App on IBM i in Under 10 Minutes - No Coding Required!
with Robert Swanson

The Valence Framework for IBM i, available for free download, includes a browser-based low-code development utility called Nitro App Builder (NAB), through which anyone with a solid understanding of their IBM i database can create dazzling web or mobile apps, including dashboards and data grids with download-to-Excel functionality, all in a matter of minutes! Running entirely on IBM i, the NAB tool can also be used to create intricate file maintenance apps, through which users can adjust content in one or more physical files - you control which fields they can see and/or edit.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML5 and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.