CREATE PROCEDURE proc1 (IN eno VARCHAR(3))
DECLARE SQLSTATE CHAR(5);
DECLARE rows_updated INTEGER;
SET = BONUS = SAL * 0.25
WHERE EMPNO = eno ;
GET DIAGNOSTICS rows_updated = ROW_COUNT;
IF rows_updated = o THEN
Is this what you are looking at ?
Originally posted by Damian Ibbotson Is there a simple way to trap the number of rows affected in a DB2 update within an SP? Hopefully something similar to Ingres' IIROWCOUNT variable.