Is there a way to caputure the name of the object that caused a trigger to be fired.
I would like to be able to know what object was used to make the insert on the table. I know I could use the ADDPFTRG and read the buffer but I would prefer of just using an sql trigger.
Thoughts?
PHP Code:
CREATE TRIGGER mm4d4pgm/JDASecurityLog4D4Insert
AFTER insert ON menSec
REFERENCING NEW ROW AS NROW
FOR EACH ROW MODE DB2SQL
BEGIN
INSERT INTO MenSecLog (F1menu, F1option, F1secuser, F1SecGroup,
F1LogUser, F1Logdate)
VALUES (NROW.SecMnm, NROW.SecMop, NRow.SecUsr, NRow.SecGrp,
User, CURRENT TIMESTAMP);
END
Thoughts?
Comment