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.
All triggers should consist only of a single call to a stored
procedure.
Add the hardcoded name of the table and action to the stored procedure
call.
Well, this is a very final statement! David has the right idea, though I would soften it just a bit - and I do mean a bit.
Any logic required by a trigger, even if it is a little complex, should be executed in a stored procedure where you have better control.
Triggers are messy and along other things, don't allow setting/resetting things like ISOLATION and PDQ.
Jay
sending to informix-list
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.