Re: Referential constraints

Luse Harold wrote: > > I would like to start putting referential constraints on our databases to > prevent some problems with invalid deletes and inserts. However, > I dimly remember being told that with Informix referential > constraints make bulk unloading and loading data a real chore. Not really. I find they make it a pleasure, because with constraints in filtering mode and violations switched on you can filter off all dud records and fix them up at your leisure. You don't even need to drop and re-create constraints, indexes and triggers. You just disable them, load and enable them when finished. > We average one complete unload and reload of our databases each year to > re-organize disk space. How? dbexport? dbimport would take care of loading for you, with or without constraints. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+