RE: turning off a trigger

Below is the set command you can use as an SQL statement, Have Fun. Gursoy YERLI To Disable set triggers for <your_table_name> disabled ; To Enable set triggers for <your_table_name> enabled ; > -----Original Message----- > From: Rob Drummond > Sent: Thursday, September 09, 1999 1:03 PM > To: informix-list@iiug.org > Subject: turning off a trigger > > I'm relatively new to Informix and am unsure how to proceed. > > I'd like to create a trigger that upon update of a record in a table, will > change the same field in one or more records of the same table by the same > amount. So if the value in the field is increased by 10 for example, that > field in another record (or records) is also increased by 10. (A second > table is used to determine which additional records are changed). > > But... > > I don't want the second change(s) to invoke the trigger, only the original > change. I think I somehow need to disable the trigger while the > subsequent > change(s) is/are made. > > TIA, > > Rob > > >