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

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.