db2v8.2执行update语句，如何查看这个语句影响的行数

存储过程里可以使用GET DIAGNOSTICS

实例代码：

CREATE PROCEDURE sqlprocg (IN deptnbr VARCHAR(3))

LANGUAGE SQL

BEGIN

DECLARE SQLSTATE CHAR(5);

DECLARE rcount INTEGER;

UPDATE CORPDATA.PROJECT

SET PRSTAFF = PRSTAFF + 1.5

WHERE DEPTNO = deptnbr;

GET DIAGNOSTICS rcount = ROW_COUNT;

db2 -m "update BILL_DETAIL  set ACCOUNT=’’, SHROFF_NAME=’’ where report_date = '20160214' and trans_amount=33.17"