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

[CRPence <CRPbottle@xxxxxxxxx>]

  V5R3.  By searching on "What's new" and "return to client":
http://www.google.com/search?q="return+to+client"+"WHAT'S+NEW"+site%3Aibm.com
  The following link:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/db2/rbafzmstwhatsnew.htm

Regards, Chuck

Vern Hamberg wrote:
> 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