Re: About integrity...

Posted in 1994

Roger J. Allen — Wed, 9 Feb 1994 01:00:10 GMT — source: Informix-list mailing list archive (1991-1998)

Jim Gordon (jgordon@ssf-sys.dhl.com) wrote: : > Anybody know, does OnLine or SE 6.0 support referential integrity : > rules CASCADES and NULLIFIES? Currently 5.0 server implements only : > RESTRICTED rule, and it's insufficient for my application task. : > : > Regards, : > Igor. : I don't know about specific facilities in 6.0 but you can implement : CASCASDES and NULLIFIES as triggers in 5.01+. If you have a ER : modelling tool like the latest version of ERwin it will automatically : create the triggers you need. : Cheers - Jim : My opinions are my own. They may vary with time but they remain MINE! : ---------------------------------------------------------------------- : Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM : Company: DHL Systems Inc Phone: (415) 375-5222 (Work) : Address: 700 Airport Blvd. #300 (415) 775-7762 (Home) : Burlingame, CA 94010-1937 Fax: (415) 375-5019 : ---------------------------------------------------------------------- The Technical Brief on "Informix-OnLine Dynamic Server Version 6.0" that I have mentions Cascading Deletes as a feature. I couldn't find the word "NULLIFIES" anywhere, but it is only a Brief. -- Roger J. Allen Rush-Presbyterian-St. Luke's Medical Center System Administrator Chicago, IL USA Surgical Information Systems Voice: (312)-942-4825 Internet: rja@sis.rpslmc.edu FAX: (312)-942-4228