I'm on UV, and the trigger subroutine for me has far more than 5 arguments... SUBROUTINE TRIGGER_EMAIL(TRIGGERNAME ,SCHEMA ,TABLE ,EVENT ,TIME ,NEWRECID ,NEWREC ,OLDRECID ,OLDREC ,ASSOC ,ASSOCEVENT ,COUNT ,CHAINCASCADE ,CASCADE)
Which in my case, TABLE, would contain the name of the triggering file. Or are you talking about the D3 triggering method (it's been years since I used it on a PC - Pick, which I currently forget the name of the implementation). George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Israel, John R. > Sent: Thursday, August 06, 2009 11:39 AM > To: 'U2 Users List' > Subject: [U2] Mass Disabling Triggers > > There are 5 arguments passed with a trigger: > STATUS.FLAG > DICT.FLAG > File Pointer > Key > Record > > The File Pointer is a handle to the OPENED file, not the NAME of the > file. How would I determine the name of the file that has the trigger > assigned to it? > > Purpose: > We have MANY triggers. Due to upgrade/conversion issues, we had to > delete all the triggers, and will need to re-add them at a later date. > This is a pain! We are considering having a single trigger for all > these files that would be smart enough to dynamically call the "real" > trigger logic (a 2nd subroutine that is locally cataloged). This would > allow us to disable the single subroutine by simply adding a RETURN at > the top of the code. Once we are ready to turn them back on, we would > just remove the RETURN. > > Other thoughts? > > > John Israel > Sr. Programmer/Analyst > Dayton Superior Corporation > 721 Richard St. > Dayton, OH 45342 > 937-866-0711 x44380 > > _______________________________________________ > 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
