IBM Mainframe Forum

I am coding a cursor to sum up the data in a number of rows. I need to report a percentage that will be:
100 * sum/number of rows

What is the best way to get a count of the number of rows without doing a separate select? Can I include the count in my cursor declaration? Is this data included somewhere in the SQLCA?

Thanks,

nevermind

Hi Christy,

You're too quick for us

What did you decide to use?

Christy,
Please let us know what the best usage considering optimum performance u achived.Because usage of COUNT(*) will be pathetic for large number of rows

well, my manager decided not to rewrite the IMS to a DB2 program (we are propagating some data and in this case I was going to use the propagated data). I was looking at the number returned in SQLERRD (3) and see if it worked for fetch only cursors and not just updates.

sqlerrd(3) does not work for cursors.
In DB2 9 you can use OLAP functions.

Thanks, Guy. Good to know.