IMHO:
*
The future of presentation technology for the platform is to present data via APIs to be consumed by 2nd-tier web applications, e.g., coded on a PowerLinux LPAR.
*
If you're architecting presentation modernization in some other fashion, you're still piling up technical debt.
________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Monday, December 30, 2024 07:20
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Tool to Modernize IBMi Screens into GUI
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
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/<
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/<
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/<
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
Jack Woehr
Independent Consulting Programmer
303-847-8442
jack.woehr@xxxxxxxxxxx
http://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.
midrange.com
