Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TRIGGER AFTER INSERT NOT WORK!

Status
Not open for further replies.

hofc

Programmer
Mar 24, 2003
5
MY
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top