informix, on delete cascade

hi, Does Informix-SE (Linux) support on Delete Cascade? (i.e. if I delete the primary key in a referencing table, will informix go through and delete all references in the referencing table). thanks, -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

halloihr@my-dejanews.com wrote: > > hi, > > Does Informix-SE (Linux) support on Delete Cascade? (i.e. if I delete the > primary key in a referencing table, will informix go through and delete all > references in the referencing table). > I believe that the ON DELETE CASCADE clause to the FOREIGN KEY constraint declaration is an Online Feature only and not available in SE. You would have to have a delete trigger run a stored procedure or delete statement in the FOR EACH ROW clause. Art S. Kagel