How to prohibit certain SQL operations ?

Posted in 1994

Thomas Kudrass — 6 Jun 1994 18:00:42 GMT — source: Informix-list mailing list archive (1991-1998)

Hallo everywhere, I'm looking for a good way to prohibit certain operations, e.g. I don't want that a table is manipulated by an UPDATE statement. But the triggers (available since version 5.0.1) don't allow me to rollback a SQL statement, because the transaction concept is only available in the embedding SQL programming linke ESQL/C. When using the BEFORE clause of the Trigger the triggering action (e.g. my bad update) has already occured, this is not desirable. Any ideas from the Informix community ? --- Thomas Kudrass kudrass@dvs1.informatik.th-darmstadt.de