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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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


HTH,
Charles

On Wed, Mar 31, 2010 at 10:55 AM, Richard Schoen
<richard@xxxxxxxxxxxxxxx> wrote:
> Hello All,
>
> I'm pretty sure this won't work, but I will ask.
>
> I have created an RPG stored procedure program that when called directly
> from the stored procedure returns recordsets just fine. Good !
>
> Would like to perform some setup stuff such as OVRDBF, etc to make sure
> lib list and other stuff is good to go.
>
> Tried putting a CL in front of the RPG call to do the overrides, but NO
> recordset gets returned.  Most likely because of the CL call between the
> SPROC and the RPG.
>
> So the questions:
>
> 1.) Can a CL program be called from a stored procedure that calls an RPG
> and ultimately returns a recordset ?   (I'm guessing not.)
>
> 2.) Is using *INZSR a better alternative that will work so I can just
> call the RPG and do all the setup stuff there.  Some of the discussions
> I've seen say that *INZSR happens before file opens, etc....
>
> Thanks in advance for any insight.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.