Your subroutine has to be globally cataloged - nothing else will work. The syntax of the create trigger that works for me is this:
CREATE TRIGGER BEFORE_INSERT BEFORE INSERT ON (FILE NAME) FOR EACH ROW CALLING "*(subroutine name)" BEFORE_INSERT - name I gave my trigger - can be anything you want (FILE NAME) - File trigger is attached to *(subroutine name) - globally cataloged subroutine that you want called Your sample subroutine below has 15 passed-in parameters and my programs only have 14 - I think you repeated the last one twice. Do I need to open the file to the SQLTRIG variable in the program? - No Do I need to open the dictionary to SCHEMA? - No Barry Rutherford Programmer / Analyst MobilexUSA 930 Ridgebrook Rd, 3rd Floor Sparks, MD 21152 Local: 443-662-4101 x 6162 Toll Free: 800-786-8015 x 6162 Fax: 443-662-4225 http://www.mobilexusa.com -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 11:47 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Universe Triggers 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 This e-mail (including any and all accompanying attachments) may contain privileged and confidential information only meant to be accessed and used by the intended recipient or the person(s) authorized to access and deliver the intended recipient's e-mail. This e-mail may contain information that is privileged or otherwise confidential. It should not be copied or forwarded to any unauthorized persons. If you received this e-mail in error, please delete it without copying or forwarding, and notify the sender by reply e-mail or by calling the MobilexUSA Privacy Office toll free at 1-866-686-1717. Thank you for your cooperation. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
