Re: Referential constraint in On-Line 7

Has anyone really tested this out on the 7.X engine? ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 12 Jun 1996, Jack Parker wrote: } > } > } It seems that Informix On-line 7 supports cascading deletes when a } > } referential integrity is violoated. When I create a foreign key } } A cascading delete is what used to be called a snowball delete. } } } Tab 1 PK Employee_id (serial) other stuff } } Tab 2 FK Employee_id (integer) other stuff } } Tab 3 FK Employee_id (integer) other stuff } } Tab 1 has the controlling key. when that employee gets deleted you want to } be sure to get all rows throughout the system with that employee id. With a } cascade delete, you delete tab 1 and all related tables (tab2 and 3) get } cleared as well. } } As far as I know it has nothing to do with the violation of referential } integrity. } } cheers } j. } _____________________________________________________________________________ } Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA } jparker@hpbs3645.boi.hp.com Back in Boise } _____________________________________________________________________________ } } If anything can go wrong, fix it. To hell with Murphy. } _____________________________________________________________________________ } Any opinions expressed herein are my own and not those of my employers. } _____________________________________________________________________________ }