Skip to main content
2 votes

DB2 TRIGGER "FOR EACH STATEMENT", with "AFTER UPDATE OR INSERT" gives SQL code -104, SQL state 42601

According to the docs, if multiple events are specified (and you specify two, update or insert), then the triggered action has to be a compiled statement (i.e. cannot be "Begin atomic"). ...
mao's user avatar
  • 217

Only top scored, non community-wiki answers of a minimum length are eligible