Re: SQL/CLI Count of rows returned in result set

On 29-May-2015 14:29 -0500, Mike Garrison wrote:

Code is as follows:
<<SNIP>>
vSQLRC = SQL_GetDescField(vDescHandle :vRecNum :SQL_DESC_COUNT
:pRowCount :vBLen :vSLen);
<<SNIP>>

AIUI the above request obtains the number of /records/ returned in the descriptor, not the estimated number of rows in a result set.


Perhaps look at the following API instead, for which the SQL_DIAG_ROW_COUNT might be the equivalent of SQLERRD(2):

<http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/cli/rzadpfndfld.htm>
SQLGetDiagField - Return diagnostic information (extensible)


And for reference, per mention of SQLERRD:

<http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzfielddescsqlca.htm>
IBM i 7.2->Database->Reference->SQL reference->SQLCA (SQL communication area)->
_Field descriptions_
SQLERRD(2) ...
...
For an OPEN statement, if the cursor is insensitive to changes, SQLERRD(2) contains the actual number of rows in the result set. If the cursor is sensitive to changes, SQLERRD(2) contains an estimated number of rows in the result set.
..."