Page 1 of 1

Getting the number of rows before fetch?

PostPosted: Sat Jul 15, 2017 1:02 pm
by jijojohn2367
Is there any way to know how many rows my cursor is going to return before fetch?
Will SQLERRD(3) contain the number of rows after OPEN CURSOR statement?

Re: Getting the number of rows before fetch?

PostPosted: Sat Jul 15, 2017 5:17 pm
by NicC
You could always do a COUNT query using the curor values. But to answer your specific question about SQLERRD(3) why not read the documentation amd if not sure after that start researching on the web - but stsrt with the official documentation.