DB2 sql 如何判断@@error

--定义数据select错误的相关异常处理的参数    declare V_tblname char(50) default 'PR_incomematch';    DECLARE rowcount integer default 0;    declare errLog       varchar(400);    declare sqlcode integer ;    declare sqlstate char(5) ;    DECLARE not_found CONDITION FOR SQLSTATE '02000';    DECLARE CONTINUE HANDLER FOR not_found        set rowcount = 0;--发生由唯一索引或唯一约束强加的约束违规    DECLARE CONTINUE HANDLER FOR SQLSTATE '23505'        set rowcount = 2;    declare exit handler for sqlexception        call logNote(V_tblname, errLog, sqlcode, sqlstate);if rowcount = 2 then  ...;else   ...;end if;
------解决方案--------------------------------------------------------
探讨

每一种error都要定义出来