Re: Calling Stored Procedure that Calls CL that Calls RPG and Returning Recordsets

What version does that come in? I don't remember it from long ago. Not sure what version Richard is going back to, but we go a
ways, usually.

So this causes the result set to go all the way back through a front-end CL? Nice if it does.


Charles Wilt wrote:

Richard...

So you have an SQL stored procedure calling an external RPG
stored procedure? And the RPG procedure returns results?

SQL Proc
|_ RPG Proc (builds RS)

And you want
SQL Proc
|_CL proc
|_ RPG Proc (builds RS)

But you don't get the results back?

In your RPG, you've got a SET RESULT SETS statement?

try changing it to
SET RESULT SETS WITH RETURN TO CLIENT