db2存储过程循环update数据，update出错怎么继续循环不使存储过程中断

[qq_20938861]

CREATE PROCEDURE UPDE_CIBB_603_PROC ( IN nelDate char(8) ,IN nelRound int,IN clsDate char(8))

LANGUAGE SQL

BEGIN

DECLARE I INTEGER DEFAULT 0;

DECLARE REFNO CHAR(28);

DECLARE SQLSTATE CHAR(5);

DECLARE SQLSTATE CHAR(3);

DECLARE CIBB CURSOR WITH HOLD FOR

SELECT REF_NO FROM CLS_IBPS_BSN_BOOK WHERE nel_Date=nelDate and nel_Round=nelRound WITH UR;

OPEN CIBB;

FETCH FROM CIBB INTO REFNO ;

WHILE (SQLSTATE = '00000')

DO

update CLS_IBPS_BSN_BOOK set CLS_DATE=clsDate,IBPS_BIZ_STATUS='PR04' WHERE REF_NO=REFNO;



SET I=I+1;

IF (MOD(I,1000)=0) THEN

SET I=0;

COMMIT;



END IF;



FETCH FROM CIBB INTO REFNO ;

END WHILE;

CLOSE CIBB;

COMMIT;

END

怎么加上异常判断呢？ 求大神 帮忙在这个存储过程上加以完善！！！！！！！！！！

[达达CockWire]

声明一个出错处理 declare continue handler for not found begin set v_end = 1; end; 在里面设置v_end的值,通过判断来控制出不出错的自定义处理