Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
A cursor within a multi-fetch cursor loop

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jdeeponline

New User


Joined: 08 Sep 2009
Posts: 27
Location: Charlotte

PostPosted: Thu Mar 06, 2014 9:43 am    Post subject: A cursor within a multi-fetch cursor loop
Reply with quote

Hi,

In a COBOL-DB2 program, I have an existing Multi-fetch Cursor that fetches upto 30 rows from a group of tables (join).

DECLARE ABC CURSOR WITH ROWSET POSITIONING FOR ...

I fetch 30 rows at a time in this program using the cursor.

FETCH NEXT ROWSET FROM ABC FOR 30 ROWS...

I have a requirement where I have to use another cursor within the loop that fetches rows from the above multi-fetch cursor, to retrive some fields from a different row(s) of the same table.

I have taken care of moving the SQLCODEs and SQLERRD(3) values to a working storage so that the new cursor doesn't interfere. But will this new cursor reset the ROWSET pointer when I try to fetch the next set of 30 rows from the multi-fetch cursor?

P.S : The reason why I have to include the new cursor is that I have a specific use case around the new select returning multiple rows. I couldn't use the -811 logic since my program uses "WHENEVER SQLERROR" to force an ABEND.

Any insight would be appreciated.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2270
Location: NY,USA

PostPosted: Fri Mar 07, 2014 12:46 am    Post subject:
Reply with quote

Quote:
I have a requirement where I have to use another cursor within the loop that fetches rows from the above multi-fetch cursor, to retrive some fields from a different row(s) of the same table.


Could you please elaborate on this? What makes you to include that within the same cursor and based on what conditions you will fetch the rows here?


Quote:
But will this new cursor reset the ROWSET pointer when I try to fetch the next set of 30 rows from the multi-fetch cursor?


Why would that be as they are two different cursors with SELECT and did you try executing it?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need to fetch data from database base... Satandale COBOL Programming 8 Sun Sep 08, 2019 12:01 am
No new posts Send text at cursor position on an IS... Domenic Ailati CLIST & REXX 10 Sun Jun 02, 2019 7:34 am
No new posts Cursor result set being updated??? John Poulakos DB2 5 Tue May 28, 2019 10:46 pm
No new posts POSITIONING THE CURSOR USING REXX MJ SHARATH CLIST & REXX 6 Tue Apr 09, 2019 10:27 am
No new posts Need to loop & extract from varia... pkmurali CLIST & REXX 2 Thu Jan 10, 2019 11:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us