I wasn't saying that it was not possible or extremely difficult. I was pointing out that the angular web app can't do direct SQL like most other languages can using ODBC or JDBC. It is just another piece to add to the learning curve of getting it working and supporting it.
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Woehr via RPG400-L
Sent: Monday, December 30, 2024 12:24 AM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Jack Woehr <jack.woehr@xxxxxxxxxxx>
Subject: 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.
midrange.com
