Re: Tool to Modernize IBMi Screens into GUI -- RPG400-L

Tried to offer a solution that is easy and WORKS. But the moderator said my
code examples were over 40K in size.

If anyone wants an example that works and is easy to do then email me.

Thomas.burrows.1957@xxxxxxxxx
mobile 469 693 2533

On Thu, Jan 2, 2025 at 2:23 PM Marco Facchinetti <
marco.facchinetti@xxxxxxxxx> wrote:

Hi Raul, Jack's sentence "you're still piling up technical debt"
represents exactly the situation we found ourselves in 6 years ago. We
could go ahead and improve some parts or completely separate the backend
side from the frontend and, luckily, we managed to realize the second way.
Today the backend part (100% RPG) serves the frontend (Js with SAPUI) using
an intermediate layer (IWS) without ever having reliability or performance
problems. Absolutely fast and satisfying.

With the same method we expose services (API) for our customers' Apps and
power the public areas (outside the standard development framework) without
having to modify anything.

If in the future the REST API style becomes obsolete we will adapt the
front end and the backend will be reusable.

HTH
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco

Il giorno mer 1 gen 2025 alle ore 01:09 Raul Alberto Jager Weiler <
raul.jager@xxxxxxxxx> ha scritto:

I do not agree, The IBM i has a great version of Apache, and a tool like
CGIDEV2 allows to write the HTML in a different file (just like DDS) and
RPG to feed or consume the data:
An extra tier makes things slower, more complicated, less reliable.

On Mon, Dec 30, 2024 at 11:29 AM Jack Woehr via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

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.
--
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.

--
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.

--
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.