Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com).
I use a master trigger that reads a list of sub-triggers based on the file name. Okay it's an extra read, but it's worth it: the list of sub-triggers (which have the same calling arguments) are all called using regular Call @ syntax; and it allows you to swap in and out sub-triggers without having to drop the main trigger, log everyone off, and recreate it. Since I first wrote that for a 24x7x365 site, that wasn't an option. Also, because UniVerse caches subroutines in memory, it means that when you recompile any changes you want to change the name e.g. MySubTrigger.1, MySubTrigger.2 and so forth. Then change the name in the sub-trigger list(s) when you are sure you've tested it. Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > George Gallen > Sent: 13 July 2009 19:51 > To: U2 Users List > Subject: [U2] which files have triggers > > Is there a way to list which tables have active triggers? > > I know about LIST.SICA tablename, but if I make a change to > the trigger program, > and I need to DROP the trigger from all the TABLES usings > it, how would I find > out all the TABLES that are using that trigger? > > Is there an easier way to DROP/CREATE when modifying a > trigger, if say the trigger is being used on 40 or 50 TABLES? > For now I'll create a PAragraph that does the CREATEing and > one that does the DROPing, and just add to each time a new > TABLE is added to that trigger, then it would just be a > matter of running the one PAragraph to drop, recompile, then > other PAragraph to CREATE. > > George > > > 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
