RE: Call RPGLE program on another iSeries

Well the problem I am trying to solve is TLS1.2 connections. The primary server does not handle it. Stuck at V6R1 for hardware limitations. (Working on that solution as well.) However, I need to post to a bank that will shut down TLS1.0 shortly. I have another iSeries at V7R2 that can and does speak with the bank. All the files and programs are on the old system. The program currently builds these large XML files, calls a program to post to the bank, then processes the return file. I just want to post these files by calling the post program on another system. The posting program is a module that accepts 5 parameters, two of which are 256 byte IFS file paths + name. I was hoping to modify this to call the program on a remote system, just modifying the path to be a shared path between the two systems.

I do not know JAVA or PYTHON or any Web stuff. The remote system does not have any web services running outside of the IBM Admin stuff.

Thinking of the data queue method as I am really familiar with them but that involves writing another service program to sit at the data queue all the time. The RPC or SQL seems the best solution for this project. Anyone done remote procedure calls? My SQL is weak but we have other programmers that can do that. I just need to give them the correct direction.


Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Tuesday, March 27, 2018 4:34 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Call RPGLE program on another iSeries

Ok Chris, based on Buck's responses, with the addition of Jim's data queue
suggestion, which of the following do you (and I realize this may be a
shot from the hip) think may do the trick?

Buck:
SQL stored procedure
Remote Procedure Call
SBMNETJOB
SBMRMTCMD
Trigger on a 'special' table on the remote system
Jim:
Data queues
Others (sorry but I deleted many of my responses):
Web Services

My initial shot from the hip would be anything with SBM in it's name would
not be the interactive response you're looking for.
The trigger idea would also not be a good command/response pair.

My initial two picks would be SQL Stored Procedures and Data queues. I
plead ignorance on remote procedure calls. Web Services may be a fun
learning experience and something to add to the tool box but I'd have to
have a lot more information to justify going down that road. At Dekko we
do some serving, and consuming, of web services. But is done by others
who do more day-to-day coding in RPG.


Rob Berendt