Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
wyang — — source: Informix-list mailing list archive (1991-1998)
I posted a question about foreign key constraint in on-line 7 yesterday.
It turns out Informix does support cascading deletion.
But the problem is, the foreig key constraint created through dbaccess
can't turn the cascading detele option on. When I created the constraint
I set this option to "Yes", but when I go back to it, the "CD" column is
set to "N". I have to run a " ALTER TABLE .... ON DELETE CASCADE". This
will set cascading delete on.
So seems there is a bug there.
Thanks for those precious replies.
Weimin
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.