Multi Fetch Cursor - Count

HameedAli · Active User Joined: 16 Apr 2009 Posts: 151 Location: India

Hi
How to figure out the no of rows fetched through Multi-Fetch Cursor?

In regular Cursor, I increment a counter after every successful fetch for calculating the no of rows fetched.

If I set the Row-set to 50, how to calculate the no of rows fetched.

gylbharat · Posted: Mon May 23, 2011 3:22 pm

SQLERRD3 contains the number of rows retrieved on the multiple-row FETCH statement

HameedAli · Active User Joined: 16 Apr 2009 Posts: 151 Location: India

Is it with regard to every fetch?

gylbharat · Posted: Mon May 23, 2011 3:33 pm

Every fetch means??

SQLERRD3 is a SQLCA variable which contains the number of rows fetched.

gylbharat · Posted: Mon May 23, 2011 3:34 pm

Refer - ibmmainframes.com/about5155.html for more information.

HameedAli · Active User Joined: 16 Apr 2009 Posts: 151 Location: India

@gylbharat, Thanks for you reference and response.

gylbharat · Posted: Mon May 23, 2011 4:29 pm