Re: About integrity...

jgordon@ssf-sys.dhl.com (Jim Gordon) writes: >> 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. OnLine 6.0 adds a new level of functionality to the CREATE TABLE statement: ON DELETE CASCADE Note: this option is only available with OnLine, not SE. You specify cascading deletes with the REFERENCES clause. Troy ============================================================================== Troy L. Hewitt, CSE INFORMIX-Federal Client Services Washington, D.C. (703) 524-3600 e-mail: troy@informix.com ------------------------------------------------------------------------------ All opinions expressed are my own and not those of Informix Software, Inc. ==============================================================================