Re: Tool to Modernize IBMi Screens into GUI

IBM has for years provided facilities for you to use RPG, SQL, or SQLRPG
to provide REST API services.
It's not that this stuff is hard; it's that our community has been slow to
adopt.
Many shops server IBM i data to modern front ends (front ends running
on-platform or on another tier such as Linux) via REST APIs successfully,
either using IBM's recipes, or commercial solutions like Midrange Dynamics
and others, as well as open source solutions such as ILEastic and others.

Create REST APIs based on SQL statements - IBM Developer<
https://developer.ibm.com/tutorials/creating-rest-apis-based-on-sql-statements/

Part 1: Building a REST service with integrated web services server for
IBM i - IBM Developer<
https://developer.ibm.com/tutorials/i-rest-web-services-server1/>
Part 2: Building a REST service with integrated web services server for
IBM i - IBM Developer<
https://developer.ibm.com/tutorials/i-rest-web-services-server2/>


________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Sunday, December 29, 2024 19:52
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Tool to Modernize IBMi Screens into GUI


Another statement that could be wrong is that unlike Java and other such
languages, the only way to access data with an Angular app is via an HTTP
request. The Angular app sends an HTTP request for the data and the data
is returned in the response. There is no way (as I understand it) for an
Angular front end to execute an SQL statement to retrieve data. I wrote a
generic rpgle program to process an SQL statement sent to it via an HTTP
request and it returns the data in JSON format but it is not efficient.
This SQL restriction also means that it can't execute a stored procedure
from an Angular app. I would assume that you could add code to your HTTP
server program to do it based on some passed criteria but I have not tried
to do anything like that. Anyone that knows different on this SQL issue,
please correct me and add some details so I can look further into this.




Jack Woehr
Independent Consulting Programmer

303-847-8442

jack.woehr@xxxxxxxxxxx

www.procern.com

Stay Connected!

Proactive. Preventive. Problems Solved.

 NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and delete/destroy
all copies of this communication immediately.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.