Re: Informix Triggers

Posted in 1998

The Wilcoxons — Wed, 8 Jul 1998 20:09:19 -0500 — source: Informix-list mailing list archive (1991-1998)

kilroi@my-dejanews.com wrote in message <6o0pvq$bu4$1@nnrp1.dejanews.com>... >Can you enforce referential integrity across databases in informix using >triggers or stored procedures? > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum You should be able to. Read up on Raising Exceptions. I saw an item that said that SPL could return an error condition. You could then have your trigger run to check for the proper validity and error if it isn't correct. S.W. wilcoxon@pioneerplanet.infi.net