× 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.


  1.  Home
  2. MIDRANGE-L
  3. March 2005

Returning multiple result sets (or cursors) from multiple programs via a single call

Experts,

I'm attempting to create a main "driver" program, (implemented as a
stored procedure), that can call separate programs that contain SQL
result set(s).  The main driver would then return these result sets (or
cursors) back to the web via ODBC.  I am able to create a driver that
will call a single program that will return multiple result sets (or
cursors).  I am failing when I try to call two separate programs that
each return a result set.  We're now looking at using sub procedures or
binding the separate calls into the driver program.  

If anyone has tried this and has a simple RPG based solution (please, no
SQL CLI or C functions), I'd be more than appreciative!!!

TIA for all your help.

Tim Chrysler

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.