Re: Avoiding triggers

david roper wrote: > > I have some triggers on tables that I do not want to execute when > certain programs access those tables. Does anyone know of a way > to do this? > > Thanks, > > David Hi David ! If you are using Informix Online V7.10.UD1 or later you have the possibility to disable triggers. If you want to disable a certain trigger the command is set triggers trigger_name disabled; If you want to disable all triggers for a certain table you have to type set triggers for table_name disabled; This command is also valid for constraints and indexes. Hope this helps ! Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------