I have SQLRPGLE program A that returns an SQL Result Set.
I would like program B to be able to call it, and read the SQL result set, ideally in a cursor
Even better, I would like program B to be able to return the SQL result set to whatever called it. And each call is over a remote SQL connection
E.g.:
Program J (on Java system) connects to IBMi A and calls Program A
Program A connects to IBMi B and calls Program B
Program B returns an SQL Result Set
Program A receives the SQL Result Set and returns it
Program J receives the SQL Result Set
And somehow, when J is done. the open cursors all get closed
Is any of this possible?
I would like program B to be able to call it, and read the SQL result set, ideally in a cursor
Even better, I would like program B to be able to return the SQL result set to whatever called it. And each call is over a remote SQL connection
E.g.:
Program J (on Java system) connects to IBMi A and calls Program A
Program A connects to IBMi B and calls Program B
Program B returns an SQL Result Set
Program A receives the SQL Result Set and returns it
Program J receives the SQL Result Set
And somehow, when J is done. the open cursors all get closed
Is any of this possible?
Comment