Hi,
I've 3 triggers in AIX box as below :
DROP TRIGGER SS_ATRG;
CREATE TRIGGER SS_ATRG AFTER INSERT ON SS
REFERENCING NEW AS NSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
DROP TRIGGER SS_UTRG;
CREATE TRIGGER SS_UTRG AFTER UPDATE OF SS_STS ON SS
REFERENCING NEW AS NSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
CREATE TRIGGER SS_DTRG AFTER DELETE ON SS
REFERENCING OLD AS OSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
All 3 triggers will call DBIQSEND UDF, the probelm now is only the 1st trigger not working. Both update & delete triggers are work fine, any body know why?
Thanks.
Regards,
fcho
I've 3 triggers in AIX box as below :
DROP TRIGGER SS_ATRG;
CREATE TRIGGER SS_ATRG AFTER INSERT ON SS
REFERENCING NEW AS NSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
DROP TRIGGER SS_UTRG;
CREATE TRIGGER SS_UTRG AFTER UPDATE OF SS_STS ON SS
REFERENCING NEW AS NSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
CREATE TRIGGER SS_DTRG AFTER DELETE ON SS
REFERENCING OLD AS OSS
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END;
All 3 triggers will call DBIQSEND UDF, the probelm now is only the 1st trigger not working. Both update & delete triggers are work fine, any body know why?
Thanks.
Regards,
fcho