Re: Update Cascade trigger

davin_harvey@dsti.co.uk wrote: > > Before the update, you could use SET CONSTRAINTS FOR table DISABLED, > then SET CONSTRAINTS FOR table ENABLED afterwards, to turn off > constraint checks. These commands are for data loading primarily, and would assume exclusive access to the tables. Remember, when enabling the constraints, ALL data rows will be checked for violations before the constraint becomes effective again. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+