RE: Returning result set from external stored procedure

[alancampin@xxxxxxxxxxx]

Will it work if you use Operations Navigator and Run Sql Scripts and call it from there?

CALL ProcedureName (parameters_separated_by_commas)

If you can get it to work from Operations Navigator, it should work from a PC program. If it will work from Operations Navigator, but not from PC then problem is at the PC level.  

As previously mentioned, it will not work if you try to call from an RPG program. 

You can, also, figure out which QZDASOINIT job you are running the stored procedure in and then look at the job log for that call. 

 -------------- Original message ----------------------
From: "Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>
> Maybe I am easily confused, but are you trying to create and pass the result set 
> with an RPG program, or are you trying to read a result set with an RPG program?
>  
> If the latter, I have had no success in accepting a result set as an input to an 
> RPG program.  I have been told at some later releases that there may be a way to 
> make it work, but haven't tried it yet.
>  
> hth, 
>  
> Dave B
>
> > > > "Wagner, Linda" <Linda.Wagner@xxxxxxxxxxx> 07/23/08 3:43 PM >>>
>
> Charles,  Yes, I've tried running it "with return" and just returning the
> open cursor.  I also tried declaring it without that and using the "set
> result sets".  Same results both times.  I've also tried it with *endactgrp
> and *endmod for the closqlcsr.  Again, same results.
>
> Buck, the message I'm referring to is the second level text for SQL7962:
>
> Message . . . . :   Cursor C1 opened.
>
> Cause . . . . . :   The cursor was opened with result set identifier of 0.
> If the result set identifier is non-zero, the result table for this cursor
> is eligible to be accessed as a stored procedure result set.
>
>
> The only other message I get regarding this is SQL7995:  0 result sets
> processed by the SET RESULT SETS.
>
> Linda
>
>
> Charles wrote:
>
> > Are you using DECLARE C1 CURSOR WITH RETURN FOR S1?
>
> > Also, make sure that nobody has change the default for CLSSQLCSR on the
> > CRTSQLxxx command ( or use a
> > SET OPTION statement in the code to control it)
>
> > HTH,
>
> > Charles Wilt 
>
> Buck wrote:
>
> > OK, what messages are you seeing in the job log?  Can you post the message
> > ID (SQLnnnn)?
> >   --buck
>
>
> -- 
> 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.