×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hey Charles,
You da man !!
Nice picture to describe what I was trying to do.
That worked perfectly once I set my library list in the CL :-)
Now I can have a CL program on the front end set up the library list as
well as handle any RPG startup errors before calling the actual RPG
driver program.
It's one more layer but I like the control aspect !!
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
------------------------------
message: 3
date: Wed, 31 Mar 2010 12:40:27 -0400
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Calling Stored Procedure that Calls CL that Calls RPG and
Returning Recordsets
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
midrange.com
