×
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.
Adding the cursor. Ok.
Then I beat myself up until I added
dynamic result sets 1
and
return;
and now this works and RSS shows me the result sets. Thanks.
create procedure rob.x
(in parm1 int,
out parm2 char( 1 ))
language sql
dynamic result sets 1
begin
declare C1 cursor with return for
select * from rob.ttable
where ( ((parm1=1) and (territory=1)) or (territory in (select
territory
from rob.terrtable)) );
open C1;
return;
end;
- Test the call here... Shows the result sets
call rob.x (1, 2);
Rob Berendt
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.
midrange.com
