Re: Triggers in Informix?

Tim Smith writes: >Are the 5.01 triggers "after statement" triggers, or do you support >the SQL3 standards for all trigger types (I think there are 12 of >them)? Offhand I do not know wtaht what SQL3 standard for triggers is, but 5.01 will support BEFORE and AFTER triggers on UPDATE, DELETE, and INSERT operations, with FOR EACH ROW clauses and WHEN clauses. So for UPDATE, DELETE, and INSERT operations, a trigger can take effect before the action or after it, you can apply the trigger action to each row and can place tests upon columns in the row to determine if the triggered action should be executed. The triggered action can be an insert, delete, update, or execute procedure statement. For update triggers, the update of individualcolumns can invoke the trigger, or the update of any column. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney