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

Il 06/05/2026 14:01, Daniel Gross ha scritto:

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

From the "Perotti method" to YAIL and IWS, I've used many tools to expose IBM i data to external systems.
Generally speaking, I have no particular technical limitations other than performance.
ILEASTIC is new to me. I took a look at it, and it seems nice, but honestly, I'm not sure how production-ready it is, and how good it is for managing something that will have a fair amount of traffic. I don't know, I should try it. Do you have it in production on something specific? Same thing for NoxDB. I've been reading about it since you mentioned it. It seems nice, but the concern is the same.
However, it's a shame that there isn't a Node library that works the same way as jt400.jar.
I tried looking at Mapepire https://github.com/Mapepire-IBMi, but it seems more like an alternative to odbc/jdbc than something I can interact with at a more defined programmatic level.