AIX 5.3 UV 10.2Universe

I want to put a trigger on a file to send an email message then a new item is written. I have read the (very non-helpful) section on triggers in the Universe System Description documentation but I'm still a bit confused. I have a program (subroutine) written with the arguments as established in the manual:

0001: SUBROUTINE NEW_TRANSFER(SQLTRIG,SCHEMA,TABLE,EVENT,TIME,NEWID,NEWREC,OLD
ID,OLDREC,ASSOC,ASSOC.EVENT,COUNT,CHAIN,CASCADE,CASCADE)

Do I need to open the file to the SQLTRIG variable in the program?
Do I need to open the dictionary to SCHEMA?


I'm assuming that trigger_name below should be the catalog name of the program"


CREATE TRIGGER trigger_name [BEFORE | AFTER] INSERT

Can someone provide a concise series of steps I need to take to set this up?

--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to