MVSFORUMS.com

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Hi All,
I have a 'odd' requirement to retrieve data from multiple instances of a table thru a Stored Procedure returning multiple

kolusu · Posted: Tue Jul 06, 2004 8:46 am Post subject:

Sureshkumar,

The cursor will be live as long as you don't execuete the GOBACK command in the stored procedure. YOu can retrieve the result set from the 5 cursors as long as they don't exceed the 32k limit.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Thanks Kolusu, but the SP is not the one that will do the fetch, the SP will issue a goback or the control is returned to the client and that application on the Distributed box is the one doing all the fetch's. thanks

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Ok, I tested it. The Cursor is live for both instances of the cursor after return to the client.