Re: stored proc with dynamic result sets 1, can I return result set in RPGLE ? how?

I have a stored proc as below, I like  to write RPGLE by issuing CALL to stored 
proc to generate result set into a file? is that possible  for below stored 
procedure format?
  
CREATE PROCEDURE MyLib.MyProcedure
IN (


VARIABLES;

)
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN





END.

Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote:
  Donna - you have to use CLI (call level interface) to get result sets 
from stored procedures in RPG. It's not too hard - you could do a 
search in the list archives and find a link to some good starting out stuff.

At 09:10 PM 11/17/2006, you wrote:

Hi
I have a stored proc as below which is very huge, when I try to 
run STRQMQRY it says SQL length is big and its failing.

I want to create a file out of this result set, since I 
understood I won't be able to call stored proc from CL program and 
QMQRY is nt working due to some constraints on my source files, I 
decided to code RPGLE in which Iam going to call this stored proc , 
my objective is when I call this RPGLE it should create a 
file/report of my resultset out of stored proc.

Some one advised me that I cannot return a result from a 
procedure in RPGLE or SQL when dynamic result sets 1 (see below 
code). You can only return a result set from a procedure when you 
are using odbc or jdbc. Is that true?

How do I create a file out of my result set in stored proc in 
RPGLE? any examples/sample code or any pointers are highly appreciated.

------------------------------------------------
I cant publish my stored proc since its very huge around 5000 lines.

CREATE PROCEDURE MyLib.MyProcedure
IN (


VARIABLES;


)
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN





END.
----------------------------------------------------------------


Thanks,

Donna.

---------------------------------
Check out the all-new Yahoo! Mail beta - Fire up a more powerful 
email and get things done faster.
--
This is the RPG programming on the AS400 / iSeries (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.