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

picobsd

我看有函数SqlDescribeCol,可没有SQLdescribeRow,请问怎么才能知道我刚刚执行的select一词返回记录的条数阿，我好分配内存阿

yapand

原帖由 picobsd 于 2008-2-28 17:59 发表
我看有函数SqlDescribeCol,可没有SQLdescribeRow,请问怎么才能知道我刚刚执行的select一词返回记录的条数阿，我好分配内存阿

我记得 odbc 中有这个 SQLRowCount

我看DB2 的 CLI 和 ODBC 接口函数差不多，你试试

picobsd

恐怕不行吧，看说明

SQLRowCount()returns the number of rows in a table that were affected by an UPDATE,INSERT,DELETE,or MERGE statement  executed against the table,or a view based on the table.SQLExecute()or SQLExecDirect() must be calledbefore calling this function.

[ 本帖最后由 picobsd 于 2008-2-29 09:51 编辑 ]

shanghang

select  count(*) from tablename

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);
   

复制代码