SQLRowCount--Get row count

Purpose

SQLRowCount() returns the number of rows in a table that were affected by an UPDATE, INSERT, DELETE, or SELECT with scrollable cursor statement executed against the table.

SQLExecute() or SQLExecDirect() must be called before calling this function.

Syntax

SQLRETURN   SQLRowCount      (SQLHSTMT          StatementHandle,   /* hstmt */
                              SQLINTEGER   FAR  *RowCountPtr);     /* pcrow */

Function arguments

표 78. SQLRowCount arguments

Usage

If the last executed statement referenced by the input statement handle is not an UPDATE, INSERT, or DELETE statement, or if it did not execute successfully, then the function sets the contents of RowCountPtr to -1.

Any rows in other tables that might have been affected by the statement are not included in the count.

Return codes

• SQL_SUCCESS
• SQL_SUCCESS_WITH_INFO
• SQL_ERROR
• SQL_INVALID_HANDLE

Diagnostics

표 79. SQLRowCount SQLSTATEs

Restrictions

None.

Related reference

• Key to DB2 CLI function descriptions
• DB2 CLI function summary
• SQLExecDirect--Execute a statement directly
• SQLExecute--Execute a statement
• SQLNumResultCols--Get number of result columns