DB2 触发器时好时坏,请帮忙
运行时错误‘-2147217881’
[db2/nt]sql0723n 在触发器“dbhtnb.delmx”中的触发SQL语句发生错误,为 该错误返回的 消息包括SQLCODE"-952",SQLSTATE "57014"和消息标记"
SQLSTATE =09000
触发器代码:
CREATE TRIGGER DelMX AFTER DELETE ON YW_BX_FYMX REFERENCING OLD AS newmx FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
call DELFYHZ(newmx.yydm,newmx.ylbh,newmx.RYSPBH,newmx.tjm,newmx.fyje,newmx.ybje);
END
存储过程:
CREATE PROCEDURE DELFYHZ(IN L_YYDM VARCHAR(30),
IN L_ZYH VARCHAR(20),
IN L_LX VARCHAR(20),
IN L_TJM VARCHAR(10),
IN L_FYJE DECIMAL(18,2),
IN L_YBJE DECIMAL(18,2))
SPECIFIC SQL070830153514542
MODIFIES SQL DATA
NOT DETERMINISTIC
NULL CALL
LANGUAGE SQL
P1: BEGIN
UPDATE YW_BX_FYMXHZB SET ZFY=ZFY-L_FYJE ,ZFJE=ZFJE-(L_FYJE-L_YBJE),TCJE=TCJE-L_YBJE WHERE YYDM=L_YYDM AND ZYH=L_ZYH AND TJM=L_TJM AND LX=L_LX;
delete from YW_BX_FYMXHZB where zfy<=0;
END P1
当我删除YW_BX_FYMX 表用 "DELETE FROM YW_BX_FYMX "
的时候会出错
当我用ADO 循环删除的时候就正常,请高手指点,急啊,谢谢了