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.
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.