The subroutine needs to be globally cataloged and therefore its name will begin with an asterisk.
CATALOG filename *BTPEMAILTRIGGER CREATE TRIGGER EMAILUPDT AFTER INSERT OR UPDATE OR DELETE ON N&ABTP FOR EACH ROW CALLING '*BTPEMAILTRIGGER' ; If you are running in a PICK flavour account then copy the CATALOG verb from the UV account and call it ICATALOG and use this in place of CATALOG in the above command. Cheers, Andy ----- Original Message ---- From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Sent: Friday, 10 July, 2009 20:19:35 Subject: [U2] UV and triggers I need to setup a trigger on a Universe file to track changes to one item. The book is quite confusing on setting up triggers... I understand how to compile the program (and read in the appropriate data). I just can't figure out how to get the trigger on the file to work I tried CREATE TRIGGER EMAILUPDT AFTER INSERT OR UPDATE OR DELETE ON N&ABTP FOR EACH ROW CALLING 'BTPEMAILTRIGGER' ; (also tried unquoted) which responds with statement triggers are not supported. I'm on Universe 10.0.2 INFORMATION FLAVOR. RELLEVEL 001 X 002 10.0.2 003 INFORMATION 004 INFORMATION.FORMAT 005 10.0.2 George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator [email protected] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
