Creating triggers

[managergtc]

Hi, dows anybody knows how to declare informix triggers, im inserting some data in my tables, but I have 1 field to be used as a timestamp and should always get the current date of the day when de record is being inserted in this table and I need to do this via a trigger. Any idea??

Thanks in advanced

 

[vpshriyan]

Hi,

You may use keywords TODAY or CURRENT to do this.

Example:

CREATE TRIGGER upd_emp
UPDATE OF emp_sal ON emp
REFERENCING OLD AS olddata NEW AS newdata
FOR EACH ROW
(INSERT INTO trace_tab VALUES
(olddata.emp_no, olddata.emp_name, olddata.emp_sal,
newdata.emp_sal, CURRENT))

You can download an e-book (pdf) version of Trigger from:

http://publibfi.boulder.ibm.com/epubs/pdf/7230a.pdf

Regards,
Shriyan