DB2自定义错误返回码?
请问谁知道DB2如何自定义错误返回码吗 使用oracle类似方法 虽然能成功执行进去 但是错误返回码并未改为自己自定义的
CREATE TRIGGER trigger_Bank
BEFORE DELETE ON Trade_BankList
REFERENCING OLD AS o
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
DECLARE v_count INTEGER;
set(v_count) = (SELECT COUNT(*) INTO FROM Trade_Bankcredit WHERE BankID = o.BankID);
IF v_count > 0 THEN
SIGNAL SQLSTATE '20021' SET MESSAGE_TEXT = 'delete error';
END IF;
END@