请问db2 c语言接口cli用什么函数可以查看刚刚执行的select语句返回记录的条数阿

Law

我查看了一下，cli调用只能得到update insert delete  SQL影响的的行数，select好像不行，不过在cli调用里面，select都是用显示游标的形式查看数据的，所以你直接在遍历数据的循环里面加个计数器吧:

原文:

1. SQLRowCount() returns the number of rows in a table that were affected by an
   
2. UPDATE, INSERT, or DELETE statement executed against the table, or a view
   
3. based on the table.
   
4. 
   
5. SQLRETURN SQLRowCount (
   
6.                 SQLHSTMT StatementHandle, /* hstmt */
   
7.                 SQLINTEGER *RowCountPtr); /* pcrow */

复制代码

1. SQLAllocHandle (SQL_HANDLE_STMT, hdbc, &hstmtparent);
   
2. cliRC = SQLExecDirect(hstmtparent, (SQLCHAR *)"delete * FROM ORG", SQL_NTS);
   
3. SQLRowCount (hstmtparent, &numRows);
   

复制代码