RE: Returning result set from external stored procedure

Linda,

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
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Wagner, Linda
Sent: Wednesday, July 23, 2008 12:39 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Returning result set from external stored procedure

I have an external stored procedure that calls an rpg program that builds
a
dynamic select statement and am having a problem getting the result set
back. The stored procedure is defined with "Result sets 1, language
rpgle,
reads sql data" and the rpg program is using "set result sets cursor C1"
to
return the result set. If I debug the program, the second level message
under "Cursor C1 opened" states the following: 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.



Does anyone know if I'm missing something or have done something
incorrectly? I'm at a loss as to what to try next.



Thanks,

Linda Wagner



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

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.