How to: |
You can create a trigger on a base table using a command line in J.D. Edwards World, or a third-party tool, such as DB Visualizer. The following example describes how to create a trigger using a command line in J.D. Edwards World.
To create a trigger on a base table:
The Enter SQL Statements screen opens.
CREATE TRIGGER JDFDATA.GIL_PO_F4311_INSERT AFTER INSERT ON JDFDATA.F4311 REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN ( N.PDDCTO='OP') BEGIN ATOMIC INSERT INTO JDFDATA.IWAY_JDE VALUES ( CURRENT DATE ,4 , CHAR(N.PDDOCO) || ','|| N.PDDCTO || ',' || CHAR(N.PDLNID) , 'INSERT' ); END
iWay Software |