Re: Call a rpg program from a node script running on an external windows or linux server

A SQL user defined table function can be a solution. But you need a ODBC connection to the machine - and this opens up a nice can of worms (deployment, security, etc.).

Another idea would be IWS - writing a small wrapper that maybe reads the data and returns it as JSON could be easier to use from the Node.js side.

Last idea is writing a small wrapper using ILEASTIC - using NoxDB you can return the result set of a SQL select as JSON quite easily. Of course you can use NoxDB also without ILEASTIC (e.g. in IWS).

It depends on what you already know, what you already use and which way you want to go in the future.

HTH
Daniel

Am 06.05.2026 um 12:01 schrieb Luca Giammattei <luca.giammattei@xxxxxxxxx>:

Hi everyone, I may soon find myself in the situation in question: a web app running on a Linux or Windows server needs to access data on the Power Server. Obviously, this involves structured information based on a well-defined and consolidated calculation in a business logic managed by three RPG programs that have been doing their job effectively for 20 years. The only change was made about twenty years ago, and a parameter was added to the programs that simply creates an PF-DTA object as an output file with this data to be later managed.
So, back to the point: what's the best way to allow a Node.js script running on a Linux (or Windows) server to connect with a specific user to a Power Server on IBM i 7.3 or 7.5 and make a call pgm1(parm1); wait a few milliseconds for the execution time and then retrieve a database file? Has anyone had similar experiences? Perhaps encapsulate the pgm in an SQL function?
Thanks in advance to anyone who can share their experiences.
--
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.